• Instructions to Ask a Question

    For any assistance, please click the "Ask a Question" button and select the Pabbly product for which you require support.

    We offer seven comprehensive applications designed to help you efficiently manage and grow your business:

    Our support team endeavors to respond within 24 business hours (Monday to Friday, 10:00 AM to 6:00 PM IST). We appreciate your understanding and patience.

    🚀 Exclusive Lifetime Offers 🚀

    We invite you to take advantage of our special one-time payment plans, providing lifetime access to select applications:

    • 🔥 Pabbly Connect — Lifetime Access for $249View Offer
    • 🔥 Pabbly Subscription Billing — Lifetime Access for $249View Offer

    Make a one-time investment and enjoy the advantages of robust business management tools for years to come.

Issue with Xero Integration: Missing Line Items in Invoices

Hello,
I am encountering an issue when transferring data from Google Sheets to Xero using Pabbly as the intermediary integration service. Our process involves the following connections:

Google Sheet to Pabbly: Purchase orders are saved in a Google Sheet. Each order can contain multiple items, and the relevant data includes customer details, invoice numbers, dates, tax types, and line items (formatted as JSON).
Pabbly to Xero: Pabbly forwards the data to Xero to create invoices. However, I’ve noticed that only the first item (0th index item) from the line items array is added to the Xero invoice. The remaining items are lost during this process.

Sample Row from Google Sheet:
CustomerID | Name | Email | InvoiceNumber | IssueDate | DueDate | TaxType | Line_Items | Done
7312 | Awais | awais.gmail.com | INV-234 | 2024-04-03T00:00:00 | 2024-04-09T00:00:00 | GST | [{"id":103,"name":"Shoes","quantity":4,"price":12.00}, {"id":101,"name":"Shirt","quantity":1,"price":17.50}] | Ok

I’m seeking guidance on how to ensure that Xero receives all line items correctly. Any insights or suggestions would be greatly appreciated.

Note: I have tried the same from Jotform with similar results i.e. only the first item appears in Xero invoice
 
P

Pabblymember11

Guest
Hey @ashper1857

Can you please share the workflow URL once, in which you have experienced the same so that we can look into it?
 
P

Pabblymember11

Guest
If you have multiple line items, we suggest using the "Line Itemizer" action step after the trigger step to process all line items simultaneously. You can trigger the Line Itemizer action step after the webhook response by enabling the "Simple Response" option. After processing the data in the Line Itemizer action step, you can map the comma-separated values in the Xero action step to the desired fields.

 
Will it add another task to each order?
I am presently within the free tasks; what will happen after the free 10000 free tasks are consumed?
Will the client be charged for the tasks consumed after that (but then what about life-time account)
 
P

Pabblymember11

Guest
Will it add another task to each order?
The Line Itemizer action step will process all the comma-separated values to the destined application at once.

Further, when a specific workflow consumes more than ten times the free tasks allocated to it, an error will occur. For instance, if a customer's Pabbly Connect account is allotted 10,000 tasks, each workflow will have a daily free task limit of 100,000 (i.e., ten times the allotted tasks).

Customers using Pabbly Connect receive a set number of tasks that they can perform within their account. Each workflow has a limit on the number of free tasks it can execute per day. Exceeding this limit results in an error.

To avoid errors and ensure smooth workflow execution, it's essential for customers to be mindful of this free task limit. If a higher free tasks count is needed, customers can consider upgrading their subscription plan to one with a higher paid tasks limit, which automatically increases the free tasks limit accordingly.
 
Top