have anyone done rest api call from workflow to get the data and store on a custom Schema? I need to pull some information from an API on weekly bases and store on a custom Data schema that I have created . The Campaign instance is on Cloud
Part answer to your query is present on this thread Invoking external REST API from Campaign Workflow
Once you have downloaded the data, inside the same JS code you can use xtk.session.Write() method to store your data to custom schema
I am trying following that . I cannot find on the documentation whats available for me to parse the HTTP Client Object so I can write the data back to a table. does anyone has an example?
I got this code here but I get only the [Object httpClientReponse]
var http = new HttpClientRequest("http://XXX")
var buffer = new MemoryBuffer();
buffer.fromString("MyLogin" + ':' + "MyPassword", "iso-8859-1");
//http.header["Authorization"] = "Basic " + buffer.toBase64();
//http.header["Content-Type"] = "text/xml; charset=utf-8";
http.method = "GET"
var resp = eval(http.response);
I guess that would depend on your architecture and implementation. Please ask your architect contact what woudl be the best solution for you.
here is the scenario:
either I can get a full dump of XML and import that to AC( Which AC doest support much on XML Load as flat file on ETL)
or us java script to make many api calls and store the data .
thats why I asked for suggestions. as far as the architect there is none it falls on me
I am looking at loading the XML data into the Adobe Campaign that is hosted on the cloud. I dont have access to the Database and also the database on this scenario is the Postgress SQL. I am very familiar with SSIS process but on this scenario is not the case