Skip to main content

Hello Experts,

 

I have used Web Request action to call SharePoint Rest API, I have received my response in below JSON format. While Iterating this collection in loop, I am not able to access name property Inside the Labels.

 

Guys How can I get name property under each row in loop.

Request you to assist me to achieve this issue.

 

22207iE768EE65A1A69B9D.jpg

 

Regards,

Sachin

You can use the action "Get item from dictionnary"



https://help.nintex.com/en-US/office365/Designer/Actions/GetanItemfromaDictionary.htm



With this action, you can query an JSON.



 



Check this post to, you can use a regex to extract your value 



https://community.nintex.com/t5/Nintex-for-Office-365-Forum/Parsing-JSON-returned-from-Query-List/m-p/36902



 



 



 


Hi - I know I’m a few years late on this one, but try the link below. You can paste your JSON response in and then determine your path to the data you need like my example below. It should return what you’re looking for. I hope this helps.


“JSON”: “<pasted response>”,

“JSONPath”: “$.labels.name”

https://developer.nintex.com/docs/nwc-tools/b3A6NzkyNTc5Mw-query-json


Reply