topic Re: Export lookup table data in Workato Pros Discussion Board

Export lookup table data

Ralef — Thu, 11 Jul 2024 12:45:34 GMT

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?

Re: Export lookup table data

gary1 — Thu, 11 Jul 2024 15:59:05 GMT

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.

Re: Export lookup table data

shivakumara — Fri, 12 Jul 2024 05:39:21 GMT

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

Re: Export lookup table data

Ralef — Wed, 17 Jul 2024 12:13:20 GMT

Yes, that was the solition, thanks!