Export lookup table data

[Ralef]

I've found a problem when I've wanted to automate exporting my lookup tables and save them in S3. I have a simple formula for S3 content:

[Entries].pluck('entry').to_json

And what I was expecting to get from it is

{
   "some_field1": 123,
   "another_field": "1qwer",
}

In reality it replaces column names with col1, col2, col3, so it looks like that

{
  "col1": 123,
  "col2": "1qwe",
}

Is there any way to persist column names or map them back?

[gary1 · Accepted solution]

The quickest way to do this is to make a variable list with the key names you want and then map the LUT response into the list. It should only require one additional task.

[Ralef]

Yes, that was the solition, thanks!

[shivakumara]

Hi @Ralef ,

Check out this solution does this helps you or not, it will not take any additional task too.

Explanation:
We can define the column as per our requirement using 'format_map' at the end we can format using to_json.

Thanks and Regards,

Shivakumara Avadhani