Answered

Help with building JSON object up within a HTTP body

(0) Share

Report

Posted on by Community Power Pla...

I am trying to dynamically create a JSON object in the body of a HTTP request. The API I am calling does not like it when I include a field with a value set to an empty string " ".

Take name for example, if this is empty then the API will throw an error. What I want is to replace the Name dynamic variable and replace with a custom expression which only includes the "name" : dyanamic_variable, when Name is not equal to " ".

I have tried this :

if(equals(items('Apply_to_each_2')['name'], " "), "", ',"name": items('Apply_to_each_2')['name'],')

EDIT for clarification:

If name is not empty JSON looks like this...

{

"name": dynamic_variable,

"custom_fields" : {

"ContactID": dynamic_variable,

"AccountNumber": dynamic_variable,

"CustomerGrade": dynamic_variable,

"EnhancedGrade": dynamic_variable,

"BranchName": dynamic_variable,

"County": dynamic_variable,

"OuterPostcode": dynamic_variable,

}

where as if name is an empty string like so " ", then the JSON looks like this:

{

"custom_fields" : {

"ContactID": dynamic_variable,

"AccountNumber": dynamic_variable,

"CustomerGrade": dynamic_variable,

"EnhancedGrade": dynamic_variable,

"BranchName": dynamic_variable,

"County": dynamic_variable,

"OuterPostcode": dynamic_variable,

}

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

CU07051257-0 on at

Like (2)

Report
Hi chrisrobbo,
Perhaps you should try to use 'null' in the expression instead of " ".
Like this:

if(equals(items('Apply_to_each_2')['name'], null), "", ',"name": items('Apply_to_each_2')['name'],')

I'm not sure, perhaps you should use this also for the result when true in the 'if' statement:

if(equals(items('Apply_to_each_2')['name'], null), null, ',"name": items('Apply_to_each_2')['name'],')

Hope this helps!
Kind regards, Jan-Pieter

PS. I think this question belongs on the PowerAutomate forum, but I don't know how to help changing that.

Was this reply helpful? Yes No
Sundeep_Malik 6,484 on at

Like (2)

Report

Hey @Anonymous

I think here, coalesce function might help you.

To read more about it, I am giving you links:

https://www.c-sharpcorner.com/article/usage-of-coalesce-function-in-power-automate/
https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-isblank-isempty

https://m.youtube.com/watch?v=bUoEjeEvDYE

https://zeitgeistcode.com/power-automate-coalesce/

So, for your case, I made a demo:
Compose contains your data without name variable:

Then next is parse json, just to parse the json data:

Next I have a compose where I have your name variable and used coalesce function in it. I have passed null single quotes to it.
Expression looks like this:
coalesce(body('Parse_JSON')?['name'],'')
You can write anything after the comma and it will show that in output:

Final Output:

If you pass a false in it with this expression, it will show false:
coalesce(body('Parse_JSON')?['name'],false)
Output:

And if I dont use coalesce function the output would be:

For your case write this expression:

coalesce(items('Apply_to_each_2')?['name'],false)
or
coalesce(items('Apply_to_each_2')?['name'],'')
I hope this will help. 🙂
If it does, do accept this answer as the solution, so in future if anyone else has this kind of doubt he can refer to this post. 🙂

Was this reply helpful? Yes No
Verified answer

Community Power Pla... on at

Like (0)

Report

I was making an error, the API I am using does accept null values so as long as the data i provide from sql has null valus then I can use the answer from the below question

https://powerusers.microsoft.com/t5/General-Power-Automate/Handling-NULL-in-Parse-JSON/td-p/40906

Was this reply helpful? Yes No