Skip to main content
Nintex Community Menu Bar

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