We currently have a contract with a vendor to provide a set of multi-language travel guides. The latest list of branded guides available can be downloaded via HTTP API call that returns a CSV file.
I have used:
SET @content = HTTPGet("API URL")
Which is successfully get the contents of the file, however I am struggling to find obvious functions to handle the content of the file. With this file I want to achieve the following:
- Loop through each row of data using the line break as the delimiter
- Split the content of each row using the "," delimiter
- Do some processing on some of the values (including splitting destination_url using "/" delimiter
- Store all these values in a Data Extension
The CSV file has approximately 1,144 rows, and has the following header rows:
Obviously once I am getting these records into a Data Extension I can use the usual Ampscript functions to lookup and find appropriate guides to include within out email campaigns.