REST api data

vendimb15716755

31-10-2017

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

Accepted Solutions (0)

Answers (7)

Answers (7)

Vapsy

Employee

01-11-2017

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

vendimb15716755

04-12-2017

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

nancyr21706845

03-12-2017

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)

vendimb15716755

30-11-2017

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

florentlb

30-11-2017

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

vendimb15716755

03-11-2017

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

vendimb15716755

02-11-2017

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);