cancel
Showing results for 
Search instead for 
Did you mean: 
Workflow Hero

retrieve data from web service

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.

0 Kudos
Reply
5 Replies
Workflow Hero

Re: retrieve data from web service

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?

0 Kudos
Accept as Solution Reply
Workflow Hero

Re: retrieve data from web service

Hi,

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

Accept as Solution Reply
Workflow Hero

Re: retrieve data from web service

No, we use SharePoint on premise 2013.

0 Kudos
Accept as Solution Reply
Workflow Hero

Re: retrieve data from web service

Is that any way that I get Jason data?

0 Kudos
Accept as Solution Reply
Workflow Hero

Re: retrieve data from web service

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.

0 Kudos
Accept as Solution Reply