Expand my Community achievements bar.

REST api data

Avatar

Level 5

HI

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

thanks

7 Replies

Avatar

Employee

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

Avatar

Level 5

Thanks Vipul

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"

http.execute();

var resp = eval(http.response);

logInfo(resp);

Avatar

Level 5

I  am good with Rest api call. One question that I have and I need sugesstion: from the performace Standpoint how AC handle multiple calls to rest apis from a Javascript task? I will need to make around 20,000 calls to pass different productno/zipcodes to get data back and store in Schema?

thanks

Avatar

Level 10

Hi,

I guess that would depend on your architecture and implementation. Please ask your architect contact what woudl be the best solution for you.

Florent

Avatar

Level 5

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

Avatar

Level 1

Hello Everyone...

Check SSIS API Package.It is awesome article where you can learn how to load data from JSON file or REST API to SQL Server (or other RDBMS systems e.g. Oracle, MySQL)

Avatar

Level 5

HI Nancyr

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

thanks