Unable to get jason value

Hi,

i am getting full jason after sending post command via http request.
i am able to get key from my jason but when i am trying to get username i am not able to get , it is giving error like “For Each: Object reference not set to an instance of an object.”

check the following screeenshots.

2
3

@Cristian_Negulescu

Here you have a full video about Json:

In your Case be Very careful you need to look for NAME NOT for USERNAME.
username is just a part of the link from self object check very well you Json structure put your JSON in NotePad++ exactly like me to see the correct structure.

yes i have watched this video.
Below jason i am getting (below is not full )
{
“message”: "Result is :{“expand”:“names,schema”,“startAt”:0,“maxResults”:15,“total”:1,“issues”:[{“expand”:“operations,versionedRepresentations,editmeta,changelog,renderedFields”,“id”:“58905”,“self”:“https://jira--8",“key”:“E2CLARITY-560”,“fields”:{“customfield_10190”:null,“customfield_10191”:null,“customfield_10192”:null,“customfield_10194”:{“self”:"https://jira-.com/sdesk/rest/api/2/customFieldOption/10276",“value”:“N”,“id”:“10276”},“customfield_10195”:{“self”:"https://jira-.com/sdesk/rest/api/2/customFieldOption/10277”,“value”:“Y”,“id”:“10277”},“customfield_10196”:{“self”:“https://jira***.com/sdesk/rest/api/2/customFieldOption/10280”,“value”:“N”,“id”:“10280”},“customfield_10197”:null,“customfield_10198”:null,“customfield_10199”:“2021-03-05T16:06:00.000+0100”,“resolution”:null,“customfield_10500”:“0.0”,“customfield_10621”:null,“customfield_10501”:“0.0”,“customfield_10622”:null,“customfield_10502”:“0.0”,“customfield_10503”:“0.0”,“customfield_10624”:{“self”:“https://jira-.com/sdesk/rest/api/2/customFieldOption/11477",“value”:“PrePaid”,“id”:“11477”},“lastViewed”:“2021-04-08T08:15:23.447+0200”,“customfield_10181”:null,“customfield_10183”:null,“customfield_10184”:null,“customfield_10185”:null,“customfield_10186”:null,“customfield_10187”:null,“customfield_10188”:null,“labels”:[“POD1”],“customfield_10620”:null,“customfield_11700”:[{“self”:"https://*****i.com/sdesk/rest/api/2/user?username=GSARANGI",“name”:“GSARANGI”,“key”:“gsarangi”,“emailAddress”:"girija.sarangi@.com”,“avatarUrls”:{“48x48”:"https://www.gravatar.com/avata

how can i separate name from jason ? i tried so many times with different different values.

use this site to format full json

and the be very carreful on movie logic

Hey here is my workflow for similar case im getting value from Jarray
GetTasks.xaml (35.6 KB) MyFolders.xaml (24.5 KB)

1 Like