POST Request with nested JSON Body - how can I generate it?

Hello,

I’m trying to send data through a JSON Body, however I think that the API receiving the data is expecting a nested JSON, with the text “inputs” in the first level, and the inputs themselves in the second level:

More details: https://developer.salesforce.com/docs/atlas.en-us.api_action.meta/api_action/actions_obj_custom_notification.htm

So in EasyMorph, I created the following action:

However, here I can’t include the first JSON level (“inputs”). At the moment this is an “Iterate Web Request” action because I was planning to use some of the columns as the values to send.

Do I need to construct this JSON structure through other actions first and then either select the column where the JSON is (Body is “Column”), or save the JSON created in a file and then upload that (Body is “File”)?

EDIT: Another option I’ve been thinking about would be, instead of constructing the JSON, just create a new column where I have the literal JSON in text and I substitute the values I want to fill out with parameters / other column values, and concatenating everything. For example:

‘"{ “inputs” :
[
{
“customNotifTypeId” : ‘&[column1]&’,
“recipientIds” : [’&{parameter1}&’],
“title” : “Custom Notification”,
“body” : “This is a custom notification.”,
“targetId” : “’&{parameter2}&’”
}
]
}’

And then I select this column as the one containing the JSON Body. What do you think?

Thanks very much,

Roberto

There are 2 options here:

The “JSON body” mode of the “Web request” action allows values to be JSON objects. If the action detects that a text value is a JSON, it inserts it as nested JSON, not as text. So you can build simple JSON objects with 1-2 levels of hierarchy.

Alternatively, use the “Construct JSON” action. It allows building JSON objects of any complexity. The web-help article contains links to examples.

So for my example, what I did was the following:

Now I have one key “inputs” and the “Value” is a calculated parameter “Notification settings” with the following expression, which builds the JSON array (here I have concatenated a parameter into the JSON array):

image

Now I’ve done the POST request and it is working. Is this what you are referring to?

Thanks!

1 Like

Great, thanks! I have modified my previous post, I placed an example where the value is a calculated parameter, where the array gets built.

Hello,

I have another requirement that involves having one of the values in the object, a string that holds a JSON (I have to send it literally, as a string wrapped in quotes):

Having added this, EasyMorph is no longer interpreting this value as a JSON, because it starts showing \r and \n in the request:

Is there a way where I can include this JSON string into the Value, and that EasyMorph stills interprets it all as a JSON?

Thanks very much,

Roberto

For complicated cases, use the “Construct JSON” action.