Unanswered

Parse JSON returns null property

(0) Share

Report

Posted on by kenneth0596

I have below output from an action and I would like to get the "invitee id" however when I parsed the output and used property "invitee id", it always returns null value. Any help is greatly appreciated.

{

"count": 1,

"results": [

{

"key": "account_invitations",

"id": "91103855"

}

"account_invitations": {

"91103855": {

"full_name": "",

"email_address": "",

"headline": null,

"pending": true,

"permission": "collaborator",

"bill_rate_in_cents": null,

"cost_rate_in_cents": null,

"billability_target": null,

"inviter_id": "11912195",

"invitee_id": "12104185",

"default_role_id": null,

"id": "91103855"

}

"meta": {

"count": 1,

"page_count": 1,

"page_number": 1,

"page_size": 20

}

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (1)

yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report

Hi @kenneth0596

Can you share a screenshot of the flow configuration? How are you creating the Parse Json Schema?

I just run a small test on my side and it worked fine.

I just copied the output you posted in the sample payload.

Schema:

Spoiler (Highlight to read)

{

"type": "object",

"properties": {

"count": {

"type": "integer"

},

"results": {

"type": "array",

"items": {

"type": "object",

"properties": {

"key": {

"type": "string"

},

"id": {

"type": "string"

}

},

"required": [

"key",

"id"

]

}

},

"account_invitations": {

"type": "object",

"properties": {

"91103855": {

"type": "object",

"properties": {

"full_name": {

"type": "string"

},

"email_address": {

"type": "string"

},

"headline": {},

"pending": {

"type": "boolean"

},

"permission": {

"type": "string"

},

"bill_rate_in_cents": {},

"cost_rate_in_cents": {},

"billability_target": {},

"inviter_id": {

"type": "string"

},

"invitee_id": {

"type": "string"

},

"default_role_id": {},

"id": {

"type": "string"

}

}

}

}

},

"meta": {

"type": "object",

"properties": {

"count": {

"type": "integer"

},

"page_count": {

"type": "integer"

},

"page_number": {

"type": "integer"

},

"page_size": {

"type": "integer"

}

}

}

}

}

{ "type": "object", "properties": { "count": { "type": "integer" }, "results": { "type": "array", "items": { "type": "object", "properties": { "key": { "type": "string" }, "id": { "type": "string" } }, "required": [ "key", "id" ] } }, "account_invitations": { "type": "object", "properties": { "91103855": { "type": "object", "properties": { "full_name": { "type": "string" }, "email_address": { "type": "string" }, "headline": {}, "pending": { "type": "boolean" }, "permission": { "type": "string" }, "bill_rate_in_cents": {}, "cost_rate_in_cents": {}, "billability_target": {}, "inviter_id": { "type": "string" }, "invitee_id": { "type": "string" }, "default_role_id": {}, "id": { "type": "string" } } } } }, "meta": { "type": "object", "properties": { "count": { "type": "integer" }, "page_count": { "type": "integer" }, "page_number": { "type": "integer" }, "page_size": { "type": "integer" } } } } }

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
kenneth0596 62 on at

Like (0)

Report

Hi @yashag2255, thanks for replying.

I have the dynamic content, what Im saying is that "invitee id" returns null value.

Was this reply helpful? Yes No
RezaDorrani 12,143 on at

Like (1)

Report

Hi @kenneth0596

Use the following expression

body('output')?['account_invitations']?['91103855']?['invitee_id']

where body('output') shoud be replaced by the dynamic content which is holding your json

Regards,
Reza Dorrani

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Was this reply helpful? Yes No
kenneth0596 62 on at

Like (0)

Report

Hey @RezaDorrani

I replaced body('output') with body('Parse_JSON') and still didnt work.

my expression looks like this: body('Parse_JSON')?['account_invitations']?['91102095']?['invitee_id'].

Was this reply helpful? Yes No
RezaDorrani 12,143 on at

Like (0)

Report

Hi @kenneth0596

Dont do parse json
just use the json object u have prior to parsing

Was this reply helpful? Yes No
Verified answer

v-bacao-msft on at

Like (0)

Report
Hi @kenneth0596 ,

It seems that because id is a dynamically changing value, even if you parse the JSON response, the property name is always changing, so you can't get the exact value.

It seems that the id value we need in the results, you could take this id first, and then use it to get invitee_id.

Expression reference:

variables('Response')['account_invitations'][outputs('Compose')]['invitee_id']

Image reference:

Hope it helps.

Best Regards,

Was this reply helpful? Yes No
eelkekramer 5 on at

Like (1)

Report

Hi @RezaDorrani,
I was having the exact same issue. Somehow all of the parsed fields are considered null, while the interface shows them having actual values.
Your answer was the fix for me. Thank you for that!
Kind regards, Eelke

Was this reply helpful? Yes No