Salesforce GraphQL Connection

Step 1. Right click on the "Connection managers" tab and select New Connection

Step 2. In the "Add SSIS Connection Manager" menu scroll down, select REST and click "Add"

Step 3. From the configuration drop-down menu select Salesforce GraphQL. From the Authentication dropdown select OAuth 2. Replace the [DomainName] placeholder with your domain.

Step 4. Press the New button to begin the token generation process and input your client_id, client_secret and optionally a scope and expiration_time.

Note: If no scope is specified, all scopes available to the app are requested.

Step 5. When prompted by Salesforce for login information, input your email and password.

Step 6: Save generated access token to file. Specify token protection password. Click OK.

Step 7. Click "Test Connection" to test your connection.

Congratulations! You have now established a connection to your Salesforce instance.

Step 1. From the configuration drop-down menu select Salesforce GraphQL. From the Authentication dropdown select OAuth 2 JWT.

2. Follow steps 1-6 from the JWT Authentication section in Cozyroc Salesforce Connection.

Step 3. Input the path to your Private Key, the private key Password and the Client Id acquired during the app creation. Lastly input the Username you use to login to Salesforce.

Step 4. Click "Test Connection" to test your connection.

Congratulations! You have now established a connection to your Salesforce instance using a JWT.

Step 1. From the configuration drop-down menu select Salesforce GraphQL. From the Authentication dropdown select OAuth 2 CC.

Step 2. Follow steps 1-6 from the OAuth2 Client Credentials section in Cozyroc Salesforce Connection.

Step 3. Input the ClientId and ClientSecret you got during App creation. Don't forget to replace the DomainName placeholder with your domain.

Step 4. Click "Test Connection" to test your connection.

Bravo! You have now established a connection to your Salesforce instance using the Client Credentials authentication.

Step 1. Open the "SSIS Toolbox" and drag and drop COZYROC "REST Source" component.

Step 2. Double click on the "REST Source" component and select a Salesforce GraphQL connection from the combo. Select from the available Salesforce GraphQL resources listed in the second combo below.
Check out the two automatically generated parameters:

1. query - the main body of the query
2. variableDefinitions - the variable definitions of a typical query

The rest of the parameters will be evaluated in the variables JSON of the GraphQL query, feel free to add/modify/delete parameters and the query body.

Step 3. The query parameter can be modified to suit your needs, all field manipulations done to the query will impact the columns of the component. The initially generated query serves just as a template.

Note: Do not surround the query parameter value with any elements, they will be automatically added, e.g. result:
query { uiapi { query { [valueHere] } } }

Step 4. The variableDefinitions parameter, much like the query parameter the value can be modified, and it will also be attached to the actual request body later on. E.g.
query accounts [valueOfTheVariableDefinitionsHere] { uiapi { query { Account(first: $first, after: $after) { ... } } }

Step 5. Click on the "Columns tab" and review the columns initialized by the query parameter.

Step 6. Click Preview to make sure all necessary resource columns are included.

Bravo! You have now learned how to read data from Salesforce GraphQL service.

Step 1. Open the "SSIS Toolbox" and drag and drop COZYROC "REST Destination" component.

Step 2. Double click on the "REST Destination" component and select Salesforce GraphQL connection from the combo. Also, select resource action and the Salesforce GraphQL resource you want to work on.
Check out the two automatically generated parameters, feel free to modify them:

1. mutation - the main body of the mutation, will be sent as is
2. variables - a template of the variables element that will contain the actual mutation data, the structure corresponds to the variable definitions and parameterization of the mutation above

Step 3. The mutation parameter can be modified to suit your needs, it will be sent as is, but if you want to change up the structure make sure to start with the variable definitions and parameters here. The actual GraphQL body represents the return data structure, if you wish to utilize some specific columns of the REST Destination Component output, you can modify the body.

Step 4. The variables parameter, much like the mutation can be modified, it serves as a template for the column initialization and the request form will follow that template.

Step 5. Click on the "Mapping" tab and map the input columns for the process you are configuring. If you want to provide input for other resource composite objects, change the input above and map the columns.

Done! You have now learned how to write data into any Salesforce GraphQL resource.