REST api data

Avatar

Avatar
Give Back 10
Level 3
vendimb15716755
Level 3

Likes

20 likes

Total Posts

107 posts

Correct reply

6 solutions
Top badges earned
Give Back 10
Give Back 5
Give Back 3
Give Back
Ignite 3
View profile

Avatar
Give Back 10
Level 3
vendimb15716755
Level 3

Likes

20 likes

Total Posts

107 posts

Correct reply

6 solutions
Top badges earned
Give Back 10
Give Back 5
Give Back 3
Give Back
Ignite 3
View profile
vendimb15716755
Level 3

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)

Avatar

Avatar
Validate 1
Employee
Vapsy
Employee

Likes

370 likes

Total Posts

726 posts

Correct reply

342 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 250
View profile

Avatar
Validate 1
Employee
Vapsy
Employee

Likes

370 likes

Total Posts

726 posts

Correct reply

342 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 250
View profile
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

Avatar

Avatar
Give Back 10
Level 3
vendimb15716755
Level 3

Likes

20 likes

Total Posts

107 posts

Correct reply

6 solutions
Top badges earned
Give Back 10
Give Back 5
Give Back 3
Give Back
Ignite 3
View profile

Avatar
Give Back 10
Level 3
vendimb15716755
Level 3

Likes

20 likes

Total Posts

107 posts

Correct reply

6 solutions
Top badges earned
Give Back 10
Give Back 5
Give Back 3
Give Back
Ignite 3
View profile
vendimb15716755
Level 3

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

Avatar

Avatar
Level 1
nancyr21706845
Level 1

Likes

0 likes

Total Posts

1 post

Correct reply

0 solutions
View profile

Avatar
Level 1
nancyr21706845
Level 1

Likes

0 likes

Total Posts

1 post

Correct reply

0 solutions
View profile
nancyr21706845
Level 1

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)

Avatar

Avatar
Give Back 10
Level 3
vendimb15716755
Level 3

Likes

20 likes

Total Posts

107 posts

Correct reply

6 solutions
Top badges earned
Give Back 10
Give Back 5
Give Back 3
Give Back
Ignite 3
View profile

Avatar
Give Back 10
Level 3
vendimb15716755
Level 3

Likes

20 likes

Total Posts

107 posts

Correct reply

6 solutions
Top badges earned
Give Back 10
Give Back 5
Give Back 3
Give Back
Ignite 3
View profile
vendimb15716755
Level 3

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

Avatar

Avatar
Give Back 50
Level 10
florentlb
Level 10

Likes

237 likes

Total Posts

1,109 posts

Correct reply

239 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 200
View profile

Avatar
Give Back 50
Level 10
florentlb
Level 10

Likes

237 likes

Total Posts

1,109 posts

Correct reply

239 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 200
View profile
florentlb
Level 10

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

Avatar

Avatar
Give Back 10
Level 3
vendimb15716755
Level 3

Likes

20 likes

Total Posts

107 posts

Correct reply

6 solutions
Top badges earned
Give Back 10
Give Back 5
Give Back 3
Give Back
Ignite 3
View profile

Avatar
Give Back 10
Level 3
vendimb15716755
Level 3

Likes

20 likes

Total Posts

107 posts

Correct reply

6 solutions
Top badges earned
Give Back 10
Give Back 5
Give Back 3
Give Back
Ignite 3
View profile
vendimb15716755
Level 3

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

Avatar

Avatar
Give Back 10
Level 3
vendimb15716755
Level 3

Likes

20 likes

Total Posts

107 posts

Correct reply

6 solutions
Top badges earned
Give Back 10
Give Back 5
Give Back 3
Give Back
Ignite 3
View profile

Avatar
Give Back 10
Level 3
vendimb15716755
Level 3

Likes

20 likes

Total Posts

107 posts

Correct reply

6 solutions
Top badges earned
Give Back 10
Give Back 5
Give Back 3
Give Back
Ignite 3
View profile
vendimb15716755
Level 3

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