Salesforce node bulk API 2.0 Upsert

Describe the problem/error/question

I’m unable to access the bulk API operations in the salesforce node and the documentation seems a bit daunting with various HTTP requests to achieve it.

Is there a simpler way to bulk import a csv file to salesforce via the n8n node?

Here’s their documentation page:

Here’s a video I watched on doing this via Postman:

I keep getting the grant_type is incorrect error whenever I tried sending an HTTP request with the Salesforce credentials saved on n8n and without the salesforce credentials.

Information on your n8n setup

  • n8n version: : 1.24.1
  • Running n8n via (Docker, npm, n8n cloud, desktop app): : elest . io app

It looks like your topic is missing some important information. Could you provide the following if applicable.

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:

Information on your n8n setup

  • n8n version: : 1.24.1
  • Running n8n via (Docker, npm, n8n cloud, desktop app): : elest . io app

Additional info:
When the Salesforce credentials weren’t working, I’ve tried setting up the connected app with all these scopes: Manage user data via APIs (api)
Manage user data via Web browsers (web)
Full access (full)
Perform requests at any time (refresh_token, offline_access)
Manage Data Cloud Ingestion API data (cdp_ingest_api)
Access the Salesforce API Platform (sfap_api)
Access all Data Cloud API resources (cdp_api)

added the client_id and client_secret and set the grant_type to ‘client_credentials’ too, but I’ve been getting a grant type not supported error.

The domain callback url is as follows: domain.my.salesforce.com/services/oauth2/callback

Not sure what I’m doing wrong, but I keep getting this unsupported grant_type error.

sheesh - I figured it out…You need to add an execution user for this to run.

For anyone facing this issue in the future, here’s the article:
https://help.salesforce.com/s/articleView?id=sf.connected_app_client_credentials_setup.htm&type=5

2 Likes

Thanks so much for posting your solution, @tre !

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.