JSON Schema with variable property name

(0) Share

Report

Posted on by Community Power Pla...

Hi,

I am working on a flow to gather information from API and load it to the database.

However, while getting the response from the API call, one of the property names is variable per account.

Then the schema I am getting from the API call is like this:

The property "12305" from the response varies from account to account. And I need to go through all accounts in one run.

Unfortunately, it is not possible to add variable content to the Schema value of the Parse JSON action.

Does anyone know the solution for that, please?

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report

Hi @Anonymous,

As a workaround you could try and use a Select action with item(). This way you at least have the list of accounts.

With an apply to each you could loop through these items and with another Select you can probably retrieve the account array specific fields.

In the screenshot below I only collected the item() in the Map field of the Select Account properties action, but you could also map to specific fields like item()['fieldname']

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi @Expiscornovus ,
Thanks for the suggestion.
Unfortunatelly it does not work for me.
The API call returns an object, that can't be used within Select action.
I as well tried to replace the id in the body, still it's an object and does not work.
I wish there was a possibility to make the schema variable.

Was this reply helpful? Yes No
Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report

Hi @Anonymous,

Apologies, I forgot it was an object. I only focused on the word array in the screenshot 😅

Can you try it with brackets around the Body field in the From. That is worth a shot.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report
so the solution for such case is following.
The JSON response needs to be converted to the string.
In the string the variable account id needs to be replaced to a static value
From the output new json needs to be created
Done.
Here are the steps printscreened:

Was this reply helpful? Yes No