Free AI web copilot to create summaries, insights and extended knowledge, download it at here

2362

Abstract

is valid for a limited period of time, but a new access token can be requested again using either the clientId and Secret or the refresh token.</p> <figure id="e681"> <div> <div>

            <iframe class="gist-iframe" src="/gist/linkerzx/344c4fe0c699e398463a6dbc746c0168.js" allowfullscreen="" frameborder="0" height="undefined" width="undefined">
          </div>
        </div>
    </figure></iframe></div></div></figure><h2 id="c667">Data Extension</h2><p id="862d">Using the rest API data events endpoint, it is possible to upload multiple mini-batch events to the salesforce marketing cloud. There is a limitation of 5MB to push and a recommendation to only send up to 50 rows at a time.</p>
    <figure id="8ce6">
        <div>
          <div>
            
            <iframe class="gist-iframe" src="/gist/linkerzx/24a8e565d2da4e2285cbde3e70725405.js" allowfullscreen="" frameborder="0" height="undefined" width="undefined">
          </div>
        </div>
    </figure></iframe></div></div></figure><h2 id="8f05">Trigger Send</h2><p id="6a04">Trigger sends work in a similar way to data extension endpoints but has different payloads that need to be provided. It contains a field Subscriber attributes that can be used to provide the data necessary to a data extension or contact update.</p>
    <figure id="daab">
        <div>
          <div>
            
            <iframe class="gist-iframe" src="/gist/linkerzx/6569586f7890a9f2069941906e2be24c.js" allowfullscreen="" frameborder="0" height="undefined" width="undefined">
          </div>
        </div>
    </figure></iframe></div></div></figure><p id="efc9">an example call can then be:</p>
    <figure id="2dbb">
        <div>
          <div>
            
            <iframe class="gist-iframe" src="/gist/linkerzx/b11238ff8333cff734aaa1910b1b9661.js" allowfullscreen="" frameborder="0" height="undefined" width="undefined">
          </div>
        </div>
    </figure></iframe></div></div></figure><p id="a546">With 202 accepted response in the following format:</p>
    <figure id="167f">
        <div>
          <div>
            
            <iframe class="gist-iframe" src="/gist/linkerzx/e434f1ee9ffa41

Options

2fb25831bf83ea419f.js" allowfullscreen="" frameborder="0" height="undefined" width="undefined"> </div> </div> </figure></iframe></div></div></figure><p id="7a16">Once the trigger send has been processed, it will update the required contact and data extension depending on the configuration set up in Salesforce Marketing Cloud.</p><h2 id="1c60">Email Delivery Status</h2><p id="47b3">When generating async trigger sends call when often want to get some insight on the status. The SFMC Rest API support these kinds of calls:</p> <figure id="0708"> <div> <div>

            <iframe class="gist-iframe" src="/gist/linkerzx/8dbf8802c06a871136edf2344495de01.js" allowfullscreen="" frameborder="0" height="undefined" width="undefined">
          </div>
        </div>
    </figure></iframe></div></div></figure><p id="fb09">With the following type of response being provided on sent success:</p>
    <figure id="372b">
        <div>
          <div>
            
            <iframe class="gist-iframe" src="/gist/linkerzx/a1efc9a6764e9c33120da5635b00414b.js" allowfullscreen="" frameborder="0" height="undefined" width="undefined">
          </div>
        </div>
    </figure></iframe></div></div></figure><p id="6470">Providing data to SFMC using its Rest API is straightforward. Setting up the different calls in python allows to set up recurring jobs easily using tools such as <a href="https://airflow.incubator.apache.org">Airflow</a>.</p><p id="14b6">Read more from me:</p><ul><li><a href="https://readmedium.com/i-hear-facebook-has-data-does-it-have-data-tools-a9f4c4d82ee7">I hear Facebook has data, does it have data tools?</a></li><li><a href="https://readmedium.com/on-the-evolution-of-data-engineering-c5e56d273e37">ON the evolution of data engineering</a></li><li><a href="https://readmedium.com/your-sql-is-not-like-my-sql-23ee9491460f">“Your SQL is not my SQL”</a></li><li><a href="https://readmedium.com/is-excel-dead-99bc550f343c">Is Excel dead?</a></li><li><a href="https://readmedium.com/do-penguins-do-analytics-e8fbb7cb4d54">Do Penguins do Analytics?</a></li><li><a href="https://readmedium.com/you-work-in-analytics-what-do-you-do-c00dc48e7ce3">You work in Analytics? What do you do?</a></li></ul></article></body>

Salesforce Marketing Cloud — Data Integration

Pushing data to Salesforce Marketing Cloud using Python

“closeup photo of clouds” by Jason Blackeye on Unsplash

Salesforce Marketing Cloud (SFMC) has two different API types in use: a Rest API and a SOAP API. Within the Python ecosystem, a library called FuelSDK integrates with the Salesforce Marketing Cloud APIs. With it, it is possible to integrate directly with SFMC. It is also possible to use automation within Salesforce Marketing Cloud to pick up data from an FTP here; however, I will focus on data integration using SFMC’s REST API.

Pushing data to Salesforce Marketing Cloud usually happen in two flavors:

A call to a data extension endpoint
A call to a trigger send endpoint.

A data extension in SFMC is a data repository backed by a MS SQL backend. It is normally used in SFMC to provide the right type of journeys for automated journeys.

The trigger send endpoint is responsible for updating your contact information with the new information, providing the data to a data extension, and trigger an email. It is usually used for transactional style of emails that need to be processed right away.

Authorization:

Authorization with the salesforce marketing cloud rest API can be done through an Oauth2 request token call:

The response is in the following JSON format and contains an access token. This token is valid for a limited period of time, but a new access token can be requested again using either the clientId and Secret or the refresh token.

Data Extension

Using the rest API data events endpoint, it is possible to upload multiple mini-batch events to the salesforce marketing cloud. There is a limitation of 5MB to push and a recommendation to only send up to 50 rows at a time.

Trigger Send

Trigger sends work in a similar way to data extension endpoints but has different payloads that need to be provided. It contains a field Subscriber attributes that can be used to provide the data necessary to a data extension or contact update.

an example call can then be:

With 202 accepted response in the following format:

Once the trigger send has been processed, it will update the required contact and data extension depending on the configuration set up in Salesforce Marketing Cloud.

Email Delivery Status

When generating async trigger sends call when often want to get some insight on the status. The SFMC Rest API support these kinds of calls:

With the following type of response being provided on sent success:

Providing data to SFMC using its Rest API is straightforward. Setting up the different calls in python allows to set up recurring jobs easily using tools such as Airflow.