The value must have a valid JSON array format.

  • 119Views
  • Last Post 4 weeks ago
0
votes
Michael Reilly posted this 04 January 2023

We found that one field is required. And when we are trying to map it is throughing an error. Please guide what we need to use & how to use that value. If possible, please provide us an example.

 

Attached Files

Order By: Standard | Newest | Votes
0
votes
Yevheniia Bilotserkovska posted this 05 January 2023

Hello Michael.

Thank you for contacting us.

In Zoho CRM API the Product Details field is an array of string. Thus, please make sure that the 'Product Details' column in your Source contains values in this format.

In other words, Products Details column expects a Source column in JSON format.

Or you can use an expression feature to fill the product details of SalesOrders in JSON format. The details on how to use the Expression Mapping are available here https://docs.skyvia.com/data-integration/common-package-features/mapping/expression-mapping.html

Please inform us about the result and do not hesitate to contact us in case of any questions.

 

Best regards,

Yevheniia Bilotserkovska

0
votes
Michael Reilly posted this 5 weeks ago

 Hello Yevheniia,

 

I'm still facing the same issue. Displaying this error: Package failed: The value for property 'Product Details' of table 'SalesOrders' is not valid. The value must have a valid JSON array format.

Is it possible to provide exact JSON value to use? So, that we can get the desired results. We tried with Column & Expression both.

0
votes
Yevheniia Bilotserkovska posted this 4 weeks ago

 

Hello Michael.

Thank you for your reply.

We will check your case and return with feedback ASAP.

Best regards,

Yevheniia Bilotserkovska

0
votes
Michael Reilly posted this 4 weeks ago

We are getting this error:

Error: required field not found. Details: {"api_name":"product","index":0,"parent_api_name":"Product_Details"}.

{"expected_data_type":"long","api_name":"product","index":0,"parent_api_name":"Product_Details"}.

 

 

And we are populating this value in the Product field details: [{"Product Name": "SFDC Import", "Quantity": "1","List Price ($)": "1000.00", "Amount ($)": "1000.00", "Discount ($)": "0.00", "Tax ($)": "0.00", "Total ($)": "1000.00"}]

0
votes
Yevheniia Bilotserkovska posted this 4 weeks ago

Hello Michael.  

Thank you for the update. 

Please try to enable the Nested Objects option and run the package again.  

Kindly inform us about the result.  

Thank you in advance and looking forward to hearing back from you.  

Best regards,  

Yevheniia Bilotserkovska

0
votes
Michael Reilly posted this 4 weeks ago

Hello Yevheniia,

 

We enabled Nested Objects under the same package but it is throwing the same error,Package failed: Unable to cast object of type 'Newtonsoft.Json.Linq.JArray' to type 'Newtonsoft.Json.Linq.JValue'. & another error as well "Columns must be assigned", even after mapping all the fields.

Even, we didn't find any relevant document related to use of Nested Option.
Is it possible to connect over a screen share session to reslove this issue?

0
votes
Yevheniia Bilotserkovska posted this 4 weeks ago

Hello Michael.

Thank you for your feedback.

We provide support via email, live chat or support portal, please use the available means of contact.

Error 'Columns must be assigned' means that the ProductDetails is required field, and since it is an array, you need to specify at least one row of this array.

Error 'Package failed: Unable to cast object of type 'Newtonsoft.Json.Linq.JArray' to type 'Newtonsoft.Json.Linq.JValue' means that the mapping of ProductDetails field is incorrect.

To correctly map the ProductDetails field, you first need to understand which array field (or it will be just a separate table) corresponds to it in Salesforce. Please check this link, it should help you to understand where and what fields you need to map https://www.zoho.com/crm/developer/docs/api/v2/sales-orders-response.html

Please try and let us know the result.

Best regards,  

Yevheniia Bilotserkovska

 

Close