Start a new topic
Discussions Joiin Forums General discussion

Pulling Categories using Joiin API

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:

  • 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.

    2 CommentsSorted by Oldest First

    Figured it out, for anyone wondering, the locations come back in headers  

     Thanks, Jack, for doing my job for me. ;) 


    I would love to know or see the results you're getting using the Joiin API if you'd be interested in sharing them in the future.


    I'll drop you an email in a couple of weeks. 

    Login or Signup to post a comment
    More topics in General discussion