Output json file for third party to parse

[Nathaniel]

Hi everyone,

I’ve taken a long break and find myself quite rusty. I’m looking to generate a json file for a third party to parse (so instead of wappler’s front end, it would be a powerautomate instance). The output would be from a database call and a structure close to:

{"result": [{"number": { "display_value": "ES0001679", "value": "ES0001679" },"u_visibility_level": { "display_value": "Red", "value": "Red" },"sys_created_on": { "display_value": "2024-12-09 12:19:40", "value": "2024-12-09 20:19:40" },"u_de_escalation_owner": { "display_value": "", "value": "" },"u_esc_executive_summary": { "display_value": "", "value": "" }}]}```

Bonus if I can restrict access with basic authentication.
Any and all pointers much appreciated.

Nathaniel.

[Teodor]

Hello,
Which of the values are dynamic and where should they come from?

[Nathaniel]

Hi @Teodor ,

The values come from a (php) database record:

The dynamic values are:

-escalationNumber
-executive_summary
-EscalationLevel
-DateOpenEscalation

From the screenshot above I can export a csv file without issue, ideally I’d like to export a json instead.

Many thanks!

[Teodor]

Is that a single query, i mean will it always return one record in the result?

[Nathaniel]

Yes, that’s correct, unless it makes more sense to do otherwise.

[Teodor]

Repeat the query, then add a group for each of the properties you need (eg. number, u_visibility_level etc) . Inside each group add two set value steps display_value and value and bind the data from the repeat:

This will output the data exactly as on your example

[Nathaniel]

Thanks for your invaluable help @Teodor , as always!