1

At the moment I try to get data from a 3rd party system into Salesforce (it must be scheduled every 5 hours)

Is there any way to integrate Data from a 3rd Party system into a DataExtension in SFMC?

I thought i can go with FTP solution but im not sure if and how i should get the data from 3rd party system in a csv fiel and upload it.

Is there any other way e.g using the API to update a DataExtension in SFMC with customer data from 3rd Party systems?

1
  • If my answer helped you, please mark it as accepted so other users can see this has been resolved. Thank you! Jun 20, 2017 at 19:24

1 Answer 1

0

You could use the Marketing Cloud REST-API for example. The call PUT /hub/v1/dataevents/key:{key}/rows/{primaryKeys} can be used to insert and update an entry in a dataextension. In addition there is also another route that allows you to upsert multiple rows at once: POST /hub/v1/dataevents/key:{key}/rowset

An example request for upserting a singe record could look like this:

Headers

Host: https://www.exacttargetapis.com

PUT /hub/v1/dataevents/11954DDF-28A3-4FE8-BF77-646C37506621/rows/Email:[email protected]

Content-Type: application/json

Authorization: Bearer YOUR_ACCESS_TOKEN

Payload:

{
    "values":{
            "LastLogin": "2013-05-23T14:32:00Z",
            "IsActive": true,
            "FirstName": "John",
            "FollowerCount": 2,
            "LastName": "Smith"
     }
}

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .