web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / ITGlue RESTful API con...
Power Automate
Unanswered

ITGlue RESTful API connection

(0) ShareShare
ReportReport
Posted on by

I am new to PowerBi and also relatively new to working with RESTful API's but has anyone been able to use an API to get data using this fasion?

james-sudora_0-1611247932083.png

After I enter the header parameters the options are anonymous, Windows, Basic, or Web API. When Web API is selected and I put in the key again and click connect but it gives me the following error message. 

james-sudora_1-1611248123671.png

 

If I use Anonymous I get the following results but I"m not sure what I should convert to.

james-sudora_2-1611248408020.png

I tried JSON but if I do that I get the following.

james-sudora_3-1611248511420.png

If I click List I get the the following

james-sudora_4-1611248556600.png

Each one of those records has an ID, Type, Attributes, and Relationships. I'm not sure how to make this data usable. This also only pulled in 50 records there should be way more than that. 

 

Categories:
I have the same question (0)
  • Reuben12 Profile Picture
    12 on at

    Hi James,

     

    Did you ever figure out how to get more than 50 records?

     

    Kind regards,

  • MattCBNZ Profile Picture
    2 on at

    For orgs i was able to just pull all results in 1 page using page[size]

     

    https://api.itglue.com/organizations?sort=id&page[size]=500

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 525 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 324 Moderator

#3
abm abm Profile Picture

abm abm 232 Most Valuable Professional

Last 30 days Overall leaderboard