Assistance Needed: Dynamic Mapping of Salesforce Data to Dynamics 365 Business Central via Azure Data Factory.

Question

Assistance Needed: Dynamic Mapping of Salesforce Data to Dynamics 365 Business Central via Azure Data Factory.

Vaibhav Patil 255

I am working on mapping Salesforce (Account or Invoice table) data to Dynamics 365 Business Central using Azure Data Factory.

Steps completed so far:

Created Linked Service for Salesforce (Test connection successful).

Created Linked Service for Business Central (REST API) (Test connection successful).

Successfully fetched and pushed data to Business Central using Postman through a Web Activity in Azure Data Factory.

Next, I want to push data from Salesforce to Business Central by dynamically mapping values from Salesforce (as the source) to Business Central (as the sink).

Getting error:

Vaibhav Patil 255 Reputation points

2024-09-16T06:49:55.2366667+00:00

after removing [0] getting error below is screenshot :
phemanth 15,755 Reputation points Microsoft External Staff Moderator

2024-09-17T13:38:20.7333333+00:00

@Vaibhav Patil We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
phemanth 15,755 Reputation points Microsoft External Staff Moderator

2024-09-18T16:50:35.84+00:00

@Vaibhav Patil was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.

1 answer

Your answer

Vaibhav Patil 255 Reputation points

2024-09-16T06:49:55.2366667+00:00

after removing [0] getting error below is screenshot :
phemanth 15,755 Reputation points Microsoft External Staff Moderator

2024-09-17T13:38:20.7333333+00:00

@Vaibhav Patil We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
phemanth 15,755 Reputation points Microsoft External Staff Moderator

2024-09-18T16:50:35.84+00:00

@Vaibhav Patil was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.

Answer 1

@vaibhav patil

Welcome to the Microsoft Q&A and thank you for posting your questions here

The error message in the image indicates a configuration issue with the REST API sink in Azure Data Factory, specifically related to client certificates and JSON formatting.

Here are some steps to help you resolve this and dynamically map data from Salesforce to Business Central:

Check Endpoint Settings: Ensure that the endpoint settings for the Business Central REST API are correctly configured. Verify that the client certificate is properly set up and that the endpoint is expecting the correct JSON format.

JSON Formatting: The error message suggests an unexpected ‘StartArray’ node was found. Ensure that the JSON being sent matches the expected format. You might need to adjust your mapping or use a transformation activity to format the JSON correctly.

Dynamic Mapping:

Create a Data Flow: In Azure Data Factory, create a data flow to handle the transformation and mapping of data from Salesforce to Business Central.

Source Transformation: Add a source transformation to read data from Salesforce.

Derived Column Transformation: Use a derived column transformation to create new columns or modify existing ones as needed.

Sink Transformation: Add a sink transformation to write data to Business Central. Ensure that the mapping is correctly set up to match the fields between Salesforce and Business Central.

Parameterization: Use parameters in your data flow to make the mapping dynamic. This allows you to handle different tables or fields without hardcoding values.

Testing: Test the data flow with a small dataset to ensure that the mapping and data transfer are working as expected.

Hope this helps. Do let us know if you any further queries.

Share via

Assistance Needed: Dynamic Mapping of Salesforce Data to Dynamics 365 Business Central via Azure Data Factory.

1 answer

Your answer