Send Look Content as CSV/File together will Look meta information like look_id, creation date, etc.

[alexsrg]

Hello, 

I have a study project and due to some limitations on our side, we need to export the Look results as a file (CSV/JSON) to the GCS bucket or SFTP.

It seems pretty easy to send the Look query result content as a file, however we also require some Look meta information (like look_id, creation date, user_id, etc.) together with this result to be able to process the result on our side.

At this moment I was not able to find a suitable solution that might export the Look metadata together with query content into the CSV or JSON file.

Do you know if there's a way I can do this? I know that by calling Get Look API method, I'll be able to get all this information, but is there any way we can export it as a file together with the content send to some location?

Thank you in advance for your attention.

I will be appreciative for any help/advice/suggestion you may provide.

[sam8]

Does the metadata need to live in the same file as the query results? If so, I don't think this is possible. 

If you're OK with sending two separate files, then you could use the API or System Activity as you mentioned to send a follow up metadata file to the same location. Maybe you could set up a process on your server that concats the files together if their titles are sufficiently similar.