
Announcements
I came across a question hope could articulate it well in this post.
From the screenshot it is a custom connector to post transaction.
The transaction came with two type of lines:
header line i.e. customer name, date etc. -> once, via a excel table 1
transaction line i.e. account code, amount, description etc. -> loop through excel table 2 with minimum of 2 lines
Previously the flow was working for static number of transaction line. But I came to realize it is common in real life to have multiple lines.
Question is how to construct the custom connector so it takes the header line once and able to have a 'apply to each' type of execution for the transaction line?
I have a vague feeling this will happen within the connector instead of the actual flow. Somehow to convert the string input for transaction line to array so the post is still one piece. Do you think it is the right starting point?
Documentation for connection:
https://developer.xero.com/documentation/api/accounting/manualjournals#post-manualjournals