Skip to main content
Dynamics 365 Community / Forums / Finance forum / Import JSON file with ...
Answered

Import JSON file with arrays using ER configuration

editSubscribe (0) ShareShare
ReportReport
Posted on by 7
Hi Friends,
 
 
We have a requirement to import a JSON file with data array into dynamics 365 using ER configuration.
Sample file is as below:
[
    {
       /Id/: /As235dd/, 
    /Invoice/: {
        /InvNumber/: /b22c1930bbcf226949ec3d5f2dd38f6e9640f0614fae44c2094fed11f314ff56/
        }
   }
]
 
We could able to import the file without array brackets in the file as shown below:

    {
       /Id/: /As235dd/, 
    /Invoice/: {
        /InvNumber/: /b22c1930bbcf226949ec3d5f2dd38f6e9640f0614fae44c2094fed11f314ff56/
        }
   }
 
 
I have tried adding DataArray object in the format of the ER configuration, but I get error as
Input file in Json format can not be deserialised.
 
 
Need help on this.
Thank you