![]() ![]() Click on the link to download a FREE trial. Basic knowledge of SSIS package development using Microsoft SQL Server Integration Services.SSIS designer installed. Sometimes it is referred as BIDS or SSDT ( download it from Microsoft site).NOTE: Salesforce Marketing Cloud is formally known as ExactTarget Requirementsīefore we look into Step-By-Step section to call Salesforce Marketing API (Exacttarget) make sure you met the following requirements. You must supply Token inside Authorization Header along with each call. Once you have token you can call any other API endpoints to read / edit / update Marketing Cloud data.Get Access Token by calling requestToken API call.Obtain ClientID and ClientSecret ( Check these steps ).In this post we will learn how to call Salesforce Marketing Cloud API using SSIS and load into SQL Server. We will show you use case of SSIS REST API Task and SSIS JSON Sourceīasically there are two steps to call Salesforce Marketing Cloud API 6 POST / Write Data to API (Insert, Update or Delete).5 Loading data from REST API to SQL Server.3.2 Step-2 : Read data from Salesforce Marketing Cloud API (SSIS JSON Source).3.1 Step-1 : Get Access Token for Salesforce Marketing Cloud API call.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |