How to read json output in SharePoint designer workflow?

Question

I am getting response in following JSON format

Affected_x0020_Program: {
results: [2]
0:  {
  __metadata: {
  id: "c6eb23d2-b6de-4f4b-a72c-052983faf36a"
  type: "SP.Data.ProgramsListItem"
}-
  Title: "Vijay"
}-
1:  {
  __metadata: {
  id: "0e2b317e-bfc9-4403-bff5-82721415982d"
  type: "SP.Data.ProgramsListItem"
}-
  Title: "Hole"
}-
-
}

How to read value of Affected_x0020_Program in SharePoint designer workflow ?

Thanks in advance.

Answer 1

First of all you need to add a "Call HTTP Web Service" action, which you might already did. Then in the "ResponseContent to" you have to assign it to a variable so that you can read from your json later.

Then you have to add a "Get an Item From a Dictionary" action where you will read from your responseContent variable.

It will show something like "Get item by name or path from dictionary (Output to item)

You will replace the item by name or path with the path of what you want from that json. In your case it would be enough if you type ProgramId.

Sorry if I explained things that you already know but you did not provide a bit more of detail. I hope this helps you. If not, please share more details