Renaming data api fields

Demir

Hi, 

I've a table that has several columns. 

A remote service calls my data APIs and queries the id and the name. However, the service requires that the json fields are "key" and "option".

Is there a way in the "Query all records" to rename "id" and "name" to "key" and "option"? I could not find a field in the "outputs" screen.

Or do I have to build a new json from the database?

Michael Udinski

You can use evals or the update variable function to add key and option to the object or update those as new field names - https://youtu.be/D3SWJYUYyP0