Automating SharePoint lists with Journeys? You'll need to configure the integration's endpoints to match your list before they'll work. Here's how.
The SharePoint integration template comes with example endpoints for creating and updating list rows, but it doesn't know what your specific list looks like. Before you can use these endpoints in a Journey, you'll need to update them with your list's actual column names.
Step 1: Find your list's internal column names
Before you can set up the endpoints, there's one quirk to know about: SharePoint columns have two names – the one you see in the interface, and a different "internal" name used behind the scenes. The payload needs the internal name.
You can look up the internal names by finding the "LISTS: Get all column headers" endpoint, clicking Test, and checking the name value in the response.
For example, a column shown as "Request Date" in SharePoint might actually be called RequestDate internally:
{
"displayName": "Request Date",
"name": "RequestDate"
}In this case, the payload field should use RequestDate, not Request Date.
Step 2: Set up the "Create row" endpoint
The template includes an endpoint for creating a new list item:
To create a list item, you need the Site ID, the List ID, and one field for each column in your list.
The template includes a sample payload with placeholder fields named YourColumn1, YourColumn2, YourColumn3, and YourColumn4. These must be replaced with the internal names of your list's columns before the endpoint will work.
Updating the endpoint
Open the Integration Builder in Journeys and find the SharePoint integration.
Locate the "LISTS: Create row (template)" endpoint.
Click the three dots on the right and select Duplicate.
Rename the duplicate to something descriptive, like "LISTS: Create row - [your list name]".
Click the three dots on the right of the duplicate and select Edit.
Replace each
YourColumnfield with the internal name of the corresponding column.
Add additional fields if your list has more than four columns.
Save the endpoint.
The same process applies to the "LISTS: Update row" endpoint: i.e. duplicate, rename, and edit the payload fields.
💭 If you have multiple SharePoint lists, repeat these steps for each list.
Step 3: Mapping values in the Journey Builder
Once your endpoint has the correct column names, go back to the action in the Journey Builder and map the correct values you want to input into each column.
