Pabbly Connect from Woocommerce to zoho sheet - json error code 2831

[GSG]

Need a little help / guidance here. I've mapped out a connection from Woocommerce to zoho sheet. When I do a save and send test request, all the data (51 columns) is correctly placed into Zoho Sheet - it works 100%.

However, when a connection is triggered by Woo (order created trigger), there is an error message which reads as follows:

Task History ID: IjcxMTEzNjkxIg_3D_3D
Step Name: Zoho Sheet > Create Row
Task Error Detail:

{
"error_message": "The parameter [json_data] required for processing this request is missing.",
"method": "worksheet.records.add",
"error_code": "2831",
"status": "failure"
}

I am not sure why the connection works when testing execution, but fails on a real life trigger (i.e. when an order is created in Woocommerce). Any suggestions for where I may be going wrong here?

Thanks

 

[Pabbly13]

Hey @GSG !

Please allow us some time to check the possibilities of your request.

We'll get back to you with an update soon.

Your kind patience will be highly appreciated.

Best Regards,

 

[GSG]

the connection to zoho sheet 'create row' was deprecated and now I cannot make any connection at all to zoho sheet. can you please advise?

 

[Pabblymember11]

Hey @GSG

We have updated the "Create Row" action event in Zoho Sheets. Kindly try the Updated one at your end and let us know how it works for you.

Thanks

 

[GSG]

Hi Thanks for the advice. Unfortunately, this has met with a dead end with a json error code 2878. Once the relevant Zoho Sheet is chosen, there are no further options that appear. Can you review and advise? Many thanks. Please see screenshot attached

 

[Pabblymember11]

Hey @GSG

We are currently looking into it and will get back to you with an update shortly.

 

[Pabblymember11]

Hey @GSG

Please try again the Create Row action event at your end. I hope now this will work for you.

Regards

 

[GSG]

that worked thank you.
The columns in Zoho Sheet map to line item meta data from woocommerce, and the data that comes over is never the same as the data from woo includes custom order information. While I have columns for this custom order data in zoho sheets, the mapping through pabbly is not recognising the data and putting it into the correct columns. For example, if a customer chooses not to have a mirror coating in the Woo order form, then the data for the next column is entered into the column before it. Is there a way around this?

 

[Pabblymember11]

Hey @GSG

Also, it seems like the data which is coming from the Trigger response is in the jumbled form, and due to which you might be facing the above concern.

So, to resolve the WooCommers' jumbled labels, you can use the "WooCommerce MetaData Extractor" which is a free task. Also for this, you need to capture the Woocommerce webhook response in advance response by switching off the toggle button.

 

[GSG]

Thanks for your assistance.

I am afraid that does not appear to help. I had in fact already tried this additional step (plus tried the formatter 'line itemizer' also), but neither worked. The line items are not broken down into identifiable line item data headings which I can then map, hence the reason why if when a dynamic order is received (i.e.., custom order), the data for the next column is entered into the column before it.

 

[GSG]

by the way I cloned the original workflow and am now using the cloned workflow to test this - which is called 'NEW RX USD'

 

[Pabblymember11]

Hey @GSG

Please allow us some time, our integration team will look into it shortly.

Thanks

 

[Pabblymember11]

Hey @GSG

We have added the Extractor action step in your workflow accordingly and due to the nested metadata which is coming in the Line Items. We have added the additional Iterator action step.

So, now you only need to map the response with the label which starts with "Res2........". Please check out the following screenshot for a better understanding and try at your end.

Regards

 

[GSG]

Hi. This was very helpful. I have largely got the workflow to work. However, there is one remaining issue.
When optional items are not chosen in the originating trigger (Woocommerce order), the action (create row to Zoho Sheet) will not allow "no data" fields to be left in the action if those options are not present. Please see screenshot attached. I am now unable to save any changes to the action without losing the mapping for those optional fields. With zapier, it was possible for "no data" mapped items to be left as is and the workflow saved, but I have not found a way to do this with Pabbly. Any suggestions?

 

[PabblyMember3]

Hi. This was very helpful. I have largely got the workflow to work. However, there is one remaining issue.
When optional items are not chosen in the originating trigger (Woocommerce order), the action (create row to Zoho Sheet) will not allow "no data" fields to be left in the action if those options are not present. Please see screenshot attached. I am now unable to save any changes to the action without losing the mapping for those optional fields. With zapier, it was possible for "no data" mapped items to be left as is and the workflow saved, but I have not found a way to do this with Pabbly. Any suggestions?

You are suggested to get all data in the trigger step for once so that, you can set up your workflow for the first time.

When it executes in real-time, it will work as intended to work but for the setup process, you need to have all the data from the trigger step.

If still, you need more help in setting up then, let us know, we will be happy to assist you.

 

[GSG]

Thanks for your continuing support on this workflow.
Based on the way the data is collected in Woo, it is not possible to trigger all the data points at the same time as there is conditional logic in the woo order trigger. I attach examples of this by way of three screenshots. The data is an either / or / or scenario, so as you can see there is not a way to trigger all of these meta data at the same time.
I was wondering if there is a way to manipulate the Pabbly "response received" data on the data transformer step by adding the data that is missed due to the conditional logic so that it appears in the final action step of creating the row in Zoho sheet? If not, then the only option I can see is to move away from conditional logic in woo - which would itself create consequent problems for us based on automation once this data arrives in Zoho Sheet.

 

[PabblyMember3]

Can you confirm if you have captured different condition-based data in the workflow history? We can get the same for setting up your workflow by posting one by one.

 

[GSG]

We have captured different condition based data in this workflow (New RX USD), and I attach details of 4 workflow history which capture all of the variables. Please review the attached for all the workflow history details.
Kindly note that this issues applies to three other workflows in exactly the same manner, and the names of these other 3 workflows are 'New RX AUD', 'New RX GBP' and 'New RX EUR'.
Thank you for the ongoing support.

 

[PabblyMember3]

Thanks for sharing the details, will check and get back to you soon.