Export to a CSV file and download

[dganguly]

Hello All,

While I was referring to this blog 

https://blog.floriancourgey.com/2021/07/adobe-campaign-insert-raw-data-in-workflow, is it possible to export the result of the records/data inserted in the temporary workflow table, abd download the same locally.

We are using Adobe Managed Acc-v8

Regards,

DG

[Craig_Thonis]

Hi Dganguly,

If you are talking about downloading the temporary data to your local computer, then you can do this by opening up any activity transition or previewing a query activity. From there you can right-click and select the export option to export and download the file locally.

You may be able to configure some javascript to export it to the local hosting machine or an SFTP site if desired, but I'll leave that to someone who is better at coding than I am .

[dganguly]

Hi @Craig_Thonis, 

When we use JS Activity to add data into the table, the way the link explained we see that the transition doesn't show that value. So we cant export the data value of the Temporary WF Table using transition.

Regards,

DG

[CedricRey · Accepted solution]

Hi,

the Craig’s answer is correct but your case is special : the JS activity doesn’t expose the new fields you may create with your script. The console won’t « see » them. 

the best way to export new values in this case is to « prepare » the table structure above (with a query or enrich activity). You have to create empty columns you will fill with empty value expression (if it’s a string, just put ‘’ in the expression, if int, then 0, if date then ##). Name it correctly (I suggest to use simple alias)

Then fill the value (with insert or update) with your script. This way, the workflow form will « know » the real table structure and expose all your datas in the preview transition form. 

cedric

[ParthaSarathy]

Hi @dganguly ,

If you are adding data/field inside the JavaScript by creating variable or instance variable, You can bring those field to transition by adding an enrichment next to JavaScript.

Example, If you are creating this two data fields in JavaScript,

 vars.field1 = '1';
 instance.vars.field2 = 'abc';

Next to JavaScript, add an enrichment, and configure the below in Add data

$(vars/@field1)
$(instance/vars/@field2)

//and Add Label and Alias for both

So that you can able to see this both field1 and field2 in enrichment transition.

And as Craig mentioned, Display the target > Right click the preview data > Export and save it in local.

[Sukrity_Wadhwa]

Hi @dganguly,

Were you able to resolve this query with the help of the given solutions or do you still need more help here? Do let us know. In case the given solutions were helpful, then kindly choose the one that helped you the most as the 'Correct Reply'.
Thanks!