Forum Discussion

Mooihoek's avatar
Mooihoek
Helper II
3 years ago

JSON Folder Import - OLE DB or ODBC error

Using the Desktop Client,  Folder option to import multiple JSON files (Combine & Transform) I get the following error:   Failed to save modifications to the server. Error returned: 'OLE DB or ODBC...
Need Help
Mooihoek's avatar
Mooihoek
Helper II
3 years ago

I see some additional steps in Queries in my pbx when I go through the Folder import compared to yours which still gives me the error.  When I update the source in the example you provided none of the data loads from the table

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago

    maybe something wonky with your JSON files.  Can you post the sample files onto a file share?

    • Mooihoek's avatar
      Mooihoek
      Helper II
      3 years ago

      You're right looks like the source files have an extra row at the end! This is causing issues