Insert rows in an empty data extension on salesforce marketing cloud by using API call

746 views Asked by At

I didn't achieve to receive data in my data extension (empty) by using the API multiple data extension rows method.

I created a data extension with 7 variables (6 data type = text, 1 is a date). One of the 7 variables is a primary key (text data type).

On postman, I created a first POST request:

  1. URL: https://mc08wx0hkc21mnr8g402m7q36hy4.auth.marketingcloudapis.com/v2/token

  2. In the body:

    { 
        "client_id": " ", 
        "client_secret": " ", 
        "account_id": " ", 
        "grant_type": " " 
    } 
    

With all the information about the package that I created on marketing cloud and that I have to use:

(scope : data extension => read, write)

By sending this request, I got my access_token.

The second part is more confused for me, I have to make the connection so as to populate my data extension.

I created a second POST request:

  1. In the body:

    Host : https://MY_SUBDOMAIN.rest.marketingcloudapis.com
    POST /hub/v1/dataevents/key: ID DataExtension/rowset
    Content-Type: application/json
    Authorization: Bearer eyJhY2Nlc...
    

The part with the URL is more confused for me. As I said before, I have one primary key in the data extension that I created to receive the datas

  1. URL: https://mc08wx0hkc21mnr8g402m7q36hy4.rest.marketingcloudapis.com/ POST /hub/v1/dataevents/key: EXTERNAL_KEY_OF_MY_DATA_EXTENSION/keys :MY_PRIMARY_KEY_NAME/

I followed the Salesforce docs.

By sending the request, I had:

<h1>596 Service Not Found</h1>
0

There are 0 answers