Dynamics Community Forum Thread Details

New Customer created through integration in D365F&O

Dear team,

I needs to create a new Customer in Customer master.

So, after discussing with my seniors, they said

We have receive the JSON data from Third party application to create a new customer in D355F&O.

So, first they will send the JSON data in to Blob storage.

From the blob storage, it should pick the JSON data to create a new Customer in D365F&O.

In the Azure blob storage, I need to create three folders like :

To be process

In process

Completed

Failed

So, first the JSON file will be in "To be process" folder. Once it's proceed , the file should be move to "In process" folder.

Once the Customer has been created , the file should be moved to "Completed" folder.

If any records failed to create a customer then that should be store in "Failed" folder as a log file.

So, the entire things I need to implement in Logic apps.

I have few queries:

1. The third party application, how they will access the Azure DevOps to put the file.

2. What to do to read the JSON file and to create a new customer in D365F&O.

3. Suppose any particular JSON data has been corrupted I mean which is failed to create the customer in D365F&O. How will I store it in Failed folder ?

4. Instead of stored failed data in Failed folder, can I use directly stagging table to filter the status with error?

4. How will I do the design for the trigger to move the file from To be process to In process and In process to Completed in Logic Apps.

Kindly elaborate please.

Thanks in advance.

Categories:

Dynamics 365 Finance

1. The third party application, how they will access the Azure DevOps to put the file.

They can use the REST web service in some way. Details are up to them.

2. What to do to read the JSON file and to create a new customer in D365F&O.

You said you'll use Logic App. There you have connectors for blob storage and F&O/data verse, as well as actions to parse JSON. But you have several options, such as using the F&O connector, using the Dataverse connector with virtual entities, transform JSON to XML and pass it to a data manegement API and so on. You need to decide what you want to do before you can implement it.

3. Suppose any particular JSON data has been corrupted I mean which is failed to create the customer in D365F&O. Where I will get the log?

Depends on 2. You need to collect requirements like this before designing the solution.

4. How will I do the design for the trigger to move the file from To be process to In process and In process to Completed in Logic Apps.

Please clarify your question. Maybe you actually want a queue instead of moving the blob.

Quick Links