retrieve data from web service

+3

I`m fresh in nintex workflow, I have a URL that retrieve data as

{"GetEmpAnd3MgrsInfoResult":[{
"FirstName":""َAmir",
"FamilyName":"Asad",
"FullName":"Amir Asad",
"Department": "HR",
"RegistryNo":"25"
}]
}

well, I need FirstName,FamilyName,... to update list item. I use web request and query xml but did not work well.

please help me to solve my problem.

+14

your web service returns data in JSON format, so query XML action will not be able to process it.

are you able to change the web service call to return XML?

+12

Hi,

Are you working with Nintex for Office 365? Here is an article shows how to parse JSON output.

+3

No, we use SharePoint on premise 2013.

+3

Is that any way that I get Jason data?

+14

I'm not sure what you mean - you already have JSON data...

to process web service response in workflow, it would be easier if you had XML.

Sign up