Developer forum

Forum » Integration » No Source Table From JSON Source Provider In Data Integration

No Source Table From JSON Source Provider In Data Integration

E-mail notifications
Bo Nyby
Reply
Posted on 09/07/2024 10:59:56

Hi.

I'm trying to set up a data integration using a JSON provider on a DW 9.12.12 solution. I'm running into an issue where no source table is found in my data:

I think the issue comes down to the formatting of my JSON file without being 100% certain. The JSON Provider documentation contains no information on the desired format from what I can see. I found the following forum post containing a snippet of some JSON and tried to replicate the format but to no avail: https://doc.dynamicweb.com/forum/integration/json-import-of-products-and-variants-fails?PID=1605

Below is an example of my JSON format (mocked values). Any ideas as to what might cause the issue?

{
  "tableName": "ProductInformations", 
  "ProductInformations": [
    {
      "StructureId": "123",
      "colorId": "abc123",
      "ItemNumber": "1234",
      "Name": "product1",
      "Language": "GB",
      "webImages": [
        {
          "Title": "product1",
          "Image": "img1.png",
          "ImagePath": "/Files/..."
        },
        {
          "Title": "product1",
          "Image": "img2.png",
          "ImagePath": "/Files/..."
        },
      ],
      "thumbnail": [
        {
          "Title": "product1",
          "Image": "img3.png",
          "ImagePath": "/Files/..."
        }
      ],
      "availableFinishingTypes": [
        {
          "Title": "finishType1",
          "Image": "img4.png",
          "ImagePath": "/Files/..."
        }
      ],
      "availableShapes": [
        {
          "Title": "Shape1",
          "Image": "img5.png",
          "ImagePath": "/Files/..."
        },
        {
          "Title": "Shape2",
          "Image": "img6.png",
          "ImagePath": "/Files/..."
        },
      ]
    },
  ]
}


Replies

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Posted on 09/07/2024 11:31:41
Reply

Hi Bo,
you can try to make a new job with selecting a JSON provider as a destination and run it, so the output of the job will be a JSON file with a Dynamicweb format structure.
The sample JSON should look like that:
[
  {
    "tableName": "EcomDetails",
    "EcomDetails": [
      {
        "DetailId": "DETAIL668",
        "DetailProductId": "PROD97",
        "DetailVariantId": ""
      },
      {
        "DetailId": "DETAIL669",
        "DetailProductId": "PROD97",
        "DetailVariantId": ""
      }
    ]
  }
]
BR, Dmitrij

 
Bo Nyby
Posted on 09/07/2024 12:26:16
Reply

Hi Dmitriy,

Thank you for your response. I've tried to use your snippet 1-to-1, but unfortunately I'm still unable to select a table. Did I misunderstand your suggestion?

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Posted on 09/07/2024 13:15:38
Reply

Hi Bo,
maybe it is too old JSON provider that you have on your Dynamicweb solution (which is also  an old one as there is 9.17 already).
Can you check if the JSON provider package is one of the last one v3.0 in the Settings -> System -> System information? And if itis not then you can update it from here:
https://www.nuget.org/packages/Dynamicweb.dataIntegration.providers.jsonprovider
BR, Dmitrij

 

 
Bo Nyby
Posted on 18/07/2024 11:35:49
Reply

Hi Dmitriy,

Sorry for the late response.

I looked at the version of our JSON provider, and it was an old version (2.0.1 I believe). I decided to abandon the JSON provider in favor of the XML provider, as that's what we have been using for the other integrations in the project, and upgrading DW is currently not in scope. Thank you for your help anyways.

Have a nice day.

Kind regards,

Bo

 

You must be logged in to post in the forum