How to perform a XERO API query within MAKE.com
11:26 07 Mar 2024

Using MAKE.com, I need to feed a given Google Sheets with a table, where rows represent Journal Lines in Manual Journals from XERO. However, I only need Journal Lines associated to a given set of accounts, say SET_OF_ACCOUNTS. My XERO instance contains 10+ organisations and I will need to fetch Journal Line details from all these Xero organisations.

My current idea is to:

1 - Establish a Xero connection with MAKE.com's Xero Module
2 - Loop over the Xero organisations and use the GET method on Manual Journals
3 - Loop over the fetched Manual Journals using their IDs and use the GET a Manual Journal method on each Manual Journal.
4 - Extract all Journal Lines from the Manual Journal, and exclude Journal Lines not associated to an account in SET_OF_ACCOUNTS
5 - Loop over the remaining Journal Lines and for each, insert a row to my pre-existing Google Sheets, whereby columns represent attributes of Journal Lines.

**What is an efficient way of implementing this procedure within MAKE.com so that the MAKE.com scenario does not take too much time to run and consumes not too many scenario operations? **

I am still stuck on step 1.

loops google-sheets make.com xero