I’m working on a project where I use Python code and make requests to an API to get specific data and then turn the output log from the code into line items which all works fine. However, now I’m having issues with trying to merge specific line items together.
To create the line items I’m using Formatter by Zapier > Text > Split Text and have my custom separator set + segment index set to “all (as separate fields)”.
Values for the line items are as follows:
Item 1 - Person name
Item 2 - Project name
Item 3 - Task name
Item 4 - Hours worked on task
Item 5 - Hourly rate
To visualise the problem with example data:
Because all the line items “item 1” are John Doe, I would like to categorise them together to create 1 invoice in Xero and then add to that invoice instead of creating multiple invoices.
Best answer by Niiikow
View original
