Expand my Community achievements bar.

SOLVED

RSS feed ETL import for adobe campaign classic

Avatar

Level 2

Would anyone know if it is possible to somehow import data from a RSS feed directly from a workflow in Adobe campagn classic? 

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi @SorenDahl 

it should be posible.

You can obtain RSS contect (xml) as a result of calling GET method, parse it if needed and store to AC table of whatever is needed.

It is not straigthforward but could be done.

Regards,

Milan

View solution in original post

6 Replies

Avatar

Correct answer by
Community Advisor

Hi @SorenDahl 

it should be posible.

You can obtain RSS contect (xml) as a result of calling GET method, parse it if needed and store to AC table of whatever is needed.

It is not straigthforward but could be done.

Regards,

Milan

Avatar

Level 2

Thank you @Milan_Vucetic!

Just to be clear, you would simply do this in a javascript activity step in a workflow? 

Avatar

Community Advisor
Hi @SorenDahl, this depends on your needs but yes I would put this in one JS node. Just one GET request, obtain response and put into table if needed. Regards, Milan

Avatar

Level 5

 Hi , Sorry might be my post is little late, so what we did for the RSS data load is :- 

1) Load or create the field structure in Adobe OOTB xls format. 

2) ftp download the xml file (the content file). 

3) Using OOTB function applyXslFromFile to validate the RSS data feed. 

4) Later assign the data to the array fields. 

5) Insert or update array data to the table.

 

Thanks,
Adithya