Error: Push Order Shipments to BigCommerce

  • 58Views
  • Last Post 06 March 2020
0
votes
Australian NaturalCare posted this 18 February 2020

We are facing an error to map our DB table field with BigCommerce Create Shipment integration. Because, BigCommerce API request parameter "items" type is array[object].

 

API reference: https://developer.bigcommerce.com/api-reference/orders/orders-api/order-shipments/createordershipments

 

How we can map MS SQL DB table field with this array[object] type field?

 

Thanks in advance

Attached Files

Order By: Standard | Newest | Votes
0
votes
Dmitriy Muzurov posted this 20 February 2020

Hello,

Thank you for submitting a ticket with us.

The field "Items" from the OrderShipments object should be mapped to a field from your database that has the following array format:

[{"OrderProductId":4,"ProductId":270,"Quantity":7}]

The field can carry more than one array separated by comma:

[{"OrderProductId":118,"ProductId":434,"Quantity":2},{"OrderProductId":117,"ProductId":436,"Quantity":1}]

Should you have any questions, do not hesitate to contact us back.

0
votes
Australian NaturalCare posted this 21 February 2020

Hi,

Thank you for your cooperation. We had tried the same JSON format but still getting the error "The value of the column Items has incorrect JSON format".

 

As per my understanding skyvia is submitting the data as a string not converting it to the JSON object. Are we have to make any change in the setting of field mapping? Please suggest

0
votes
Australian NaturalCare posted this 04 March 2020

Hello,

We discuss with BigCommerce Support Team. They need the API call detail that the Skyvia is making when trying to interact with BigCommerce to create the Order Shipment. Would you be able to provide us with the API call detail? This will help BigCommerce Support to confirm that if there is any incorrect information being delivered to BigCommerce. However, They do have a firm belief that this is more of an issue with Skyvia's system than BigCommerce.

0
votes
Dmitriy Muzurov posted this 06 March 2020

Hello,

Thank you for your replies.

We have just managed to create new OrderShipment both from a CSV file and MySQL table as sources.

The value for Items should be passed as a string but in array format - inside of curly brackes surrounded by square brackets.

We asked the development team to provide the data you requested and will post the update here as soon as we get it.

Close