https://app.skyvia.com/#/69950/packages/116908/debug

  • 24Views
  • Last Post 23 June 2021
0
votes
Jason Rainbird posted this 18 June 2021

When I run the process I get the following error message.

Unable to cast object of type 'Newtonsoft.Json.Linq.JValue' to type 'Newtonsoft.Json.Linq.JArray'.

Order By: Standard | Newest | Votes
0
votes
Sabina Bashuk posted this 22 June 2021

Hello Jason,

Thank you for contacting Skyvia Support!

I have created a support request to troubleshoot your issue and will update you as soon as I can.

Thank you for your patience and understanding!

0
votes
Sabina Bashuk posted this 23 June 2021

Hello Jason,

We have checked and found out that the error appears while reading the Persons table. You have added the "Mobile Phone" column this way:

{ "Name": "Mobile Phone", "APIPath": "6a0a19261c799c03533f7d1a178712fdb71009c8", "DbType": "JsonArray" }

Looks like it is not "JsonArray" type. 

Please try to set "DbType": "String" and check if the issue persists.

Close