Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

Search API and Enter data into form

Like (1) ShareShare
ReportReport
Posted on 12 Sep 2024 17:46:44 by 69
I am very new to API and want to practice. What I am trying to learn is how to call an API and use some of that data as default values for my form. 
 
I want to be able to search by NCTID and get information for that study.
 
This is the api https://clinicaltrials.gov/api/v2/studies I am testing with. 
 
 
This is what the power automate looks like
 
 
this is what part of the payload looks like
 
This is the error I am getting.
 
Can anyone help with this, also what do I need to do in power automate to be able to search and get results just for the nctID. Any help would be greatly appreciated, Thanks
  • Verified answer
    FLMike Profile Picture
    FLMike 29,371 on 12 Sep 2024 at 20:47:19
    Search API and Enter data into form
    Hi
     
    If you look at your Payload its an Object, it says it right there.
     
    You have studies with a [ that means object. Cant use that. Need to figure out what you really need and grab that or convert what you have into an Array
     

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

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #9 Get Recognized…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 144,316

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 64,290

Leaderboard
Loading complete