JSONPATH

[Esam Naas]

Hi,
I'm not able to filter in dynamic drop down menu using action receives HTTP
service results in json.
see example
JSON:
{
"firstName": "John",
"lastName" : "doe",
"age" : 26,
"address" : {
"streetAddress": "naist street",
"city" : "Nara",
"postalCode" : "630-0192"
},
"phoneNumbers": [
{
"type" : "iPhone",
"number": "0123-4567-8888"
},
{
"type" : "home",
"number": "0123-4567-8910"
}
]
}

JSONPATH
$.phoneNumbers[?(@.type=='home')]

Results
[
{
"type": "home",
"number": "0123-4567-8910"
}
]


please help
Regards,
Esam


--
Sent from: http://discuss.orbeon.com/

[Alessandro Vernet]

Hi Esam,

The expression would be `/json/phoneNumbers/_[type = 'home']`, and then I
imagine you could use `number` for both the label and value in the dropdown.

xpath.png <http://discuss.orbeon.com/file/t119778/xpath.png>

BTW, you can see that the structure of the XML that corresponds to your JSON
is by going to the HTTP Service Editor dialog, after entering the URL for
your service hitting Test, and then going to the Test Results / XML Response
Body tab. You'll let me know if this works for you.

http-service-editor.png
<http://discuss.orbeon.com/file/t119778/http-service-editor.png>

‑Alex

-----
--
Follow Orbeon on Twitter: @orbeon
Follow me on Twitter: @avernet

[Esam Naas]

Perfect worked like charm thanks

[Alessandro Vernet]

Perfect Esam, and thank you for the confirmation.

‑Alex

-----
--
Follow Orbeon on Twitter: @orbeon
Follow me on Twitter: @avernet

[Esam Naas]

Quick one, can I feed 3 drop down menus with one http service please?
At the moment I'm using 3 http with 3 actions to populate data

Regards,

Esam

[Alessandro Vernet]

Hi Esam,

Yes, you can! In the "Actions Editor" dialog, in the "Service Response
Actions" tab, click 3 times on the "+" icon (see screenshot below), and on
each row you can define the control to populate and the expressions to use
to extract the choices from what the service returns.

populating-multiple-dropdowns.png
<http://discuss.orbeon.com/file/t119778/populating-multiple-dropdowns.png>

You'll let me know if this works for you,

‑Alex

-----
--
Follow Orbeon on Twitter: @orbeon
Follow me on Twitter: @avernet

[Esam Naas]

Done, figured it out same day.

[Alessandro Vernet]

Perfect Esam, and thank you for the confirmation!

‑Alex

-----
--
Follow Orbeon on Twitter: @orbeon
Follow me on Twitter: @avernet