I’ve got the Joiin API working and can pull a consolidated P&L into Power Query, though now I’m trying to break it out by location (tracking category). In the Joiin UI I can easily show P&L by location as columns, so I know the data is there.
Has anyone been able to:
Pull P&L data split by tracking category via the API
Filter by categoryOptionNames successfully?
I am trying to avoid having to rebuild everything from Xero or rely on exports if possible.
1 Comment
J
Jack Mangini
said
3 minutes ago
Figured it out, for anyone wondering, the locations come back in headers
Jack Mangini
Hello,
I’ve got the Joiin API working and can pull a consolidated P&L into Power Query, though now I’m trying to break it out by location (tracking category). In the Joiin UI I can easily show P&L by location as columns, so I know the data is there.
Has anyone been able to:
I am trying to avoid having to rebuild everything from Xero or rely on exports if possible.