Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Converting JSON to variables

Hello, I am attempting to take information from a Zendesk ticket and update a corresponding ticket in SharePoint with the same information. This should be an easy task but for some reason my Zendesk connector is returning my custom fields as blank - and also only returning one value for 'custom_field' when there are many. 


So I tried using HTTP GET to pull the information from the ticket. From that I got JSON, I took that and then parsed it to try to put it in an array.

Here is my flow now:



I am assuming that I somehow need to get these values into a bunch of variables (or dynamic content) to be able to use later on in the flow. Or does anyone else have any suggestions? 


The return I am getting from 'Compose 2' looks like this: (Note: this is one example of the many different outputs)


Which is the information I need; but I need a way to say Update Sharepoint by putting "360039462673" in column "Progress". The only dynamic output I am getting from the Parse JSON 2 is "id"


Any help or suggestions is greatly appreciated. 


Thank you. 


Helpful resources

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group


Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Top Kudoed Authors
Users online (61,048)