Skip to main content

Notifications

Power Automate - Using Connectors
Unanswered

Connecting to trello json file

(0) ShareShare
ReportReport
Posted on by 26

Hi all,

 

I'm a flow newbie, so go easy Smiley Happy

 

I've built a PowerBI report connecting to the json file from a trello board (using this excellent tutorial here). It works great, but involves manually downloading the json file to update it. 

 

The way I do the download is to use the URL from my trello board, with a '.json' at the end. I can then save that page as a json file and point my power BI report to that.  It works perfectly.  But it's still manual, so I'd like to automate it, but I'm struggling.

 

Any help on how I could get flow to regularly get the json file and save it (either to onedrive or sharepoint) that would be really great.  I could then schedule the PowerBI refresh as normal.

 

Thanks in advance 🙂

  • desreed Profile Picture
    desreed 26 on at
    Re: Connecting to trello json file

    Thank you Barry , @v-bacao-msft 

     

    The board I have is a private one.  I'm guessing that's the issue then with this solution.

     

    Does anyone know of a way to get the data from a private board in an automated way?  I don't have a paid-for subscription to trello, just the free service.

     

    Thanks

    Derek

  • v-bacao-msft Profile Picture
    v-bacao-msft on at
    Re: Connecting to trello json file

     

    Hi @desreed ,

     

    I tested it on my side. If the Board are private, I can't get the data.

    For reference, the board I used for testing here is public.

     

    Best Regards,

  • desreed Profile Picture
    desreed 26 on at
    Re: Connecting to trello json file

    Hi Barry @v-bacao-msft 

     

    Thanks for the advice.  I had tried that before posting, but have tried again and checked through with the details you've kindly given in your advice.  Unfortunately it fails.  For the HTTP step, I get an error message:

     

    Status : 401

    Body : Unauthorised permission requested

     

    Does flow have different levels of access for different accounts?  e.g. is the http step something that you need a higher level of microsoft account to access?  If so, that may be it.  I don't know what level access I have as it's through the organisation I work for in the UK.

     

    Thanks again for your advice so far.

    Derek

  • v-bacao-msft Profile Picture
    v-bacao-msft on at
    Re: Connecting to trello json file

     

    Hi @desreed ,

     

    Please try using HTTP action to get JSON File.

    • Fill the URL of the file in the URI field and use Get method to get the file content.
    • Then consider storing the file in OneDrive and setting up a scheduled refresh.

    Image reference:

    56.PNG

    Please take a try.

     

    Best Regards,

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,304

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard

Featured topics