cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
zdames
Level: Powered On

Connecting Custom API

Hi everyone!

 

I've been tryong to connect NASA APOD's API in PowerApps but I've been receiving an error everytime I call my connector:

Untitled.png

My get:

Capture.PNGRequestCapture.PNGResponse I get

Now I'm confused, what is causing this error to come up and why I cant pull down the data from API? Some were sucessful when they pulled in the data via flows, but now as a custom connector, it cannot work? Appreciate everyone's response 🙂 

3 REPLIES 3
Super User
Super User

Re: Connecting Custom API

Hi @zdames

What property are you trying to set here? For instance, are you trying to show the result of the API call in a gallery or in a label?

If you add a button to your screen, can you successfully ClearCollect the API call to a new collection, and view the collection from the designer?

 

Highlighted
Community Support Team
Community Support Team

Re: Connecting Custom API

Hi @zdames,

Which Response type do you specify within your Open API definition file?

Could you please share more details about the Open API definition file of your custom connector?

Based on the error message that you provided, it seems to tell that the property (query parameter) of the control is required to provide a Table value, but your custom connector formula return a Text value.

Based on the Response screenshot that you provided, I think you have defined your Response type as Object within your OpenAPI definition file, is it true?

Please consider take a try to define your Response type as array within your OpenAPI definition file as below:

{
  "swagger": "2.0",
  "info": {
    "version": "1.0.0",
    "title": "SentimentDemo",
    "description": "Uses the Cognitive Services Text Analytics Sentiment API to determine whether text is positive or negative"
  },
  "host": "westus.api.cognitive.microsoft.com",
  "basePath": "/",
  "schemes": [
    "https"
  ],
  "consumes": [],
  "produces": [
    "application/json"
  ],
  "paths": {
    "/text/analytics/v2.0/sentiment": {
      "post": {
        "summary": "Returns a numeric score representing the sentiment detected",
        "description": "The API returns a numeric score between 0 and 1. Scores close to 1 indicate positive sentiment, while scores close to 0 indicate negative sentiment.",
        "operationId": "DetectSentiment",
        "parameters": [
          {
            ...
          }
        ],
        "responses": {
          "200": {
            "description": "200",
            "schema": {
              "type": "array",  /* <-- Modify here. Change the Response type from object into array */
              "properties": {
                "documents": {
                  "type": "array",
                  "items": {
                    "type": "object",
                    "properties": {
                    }
                  },
                  "description": "documents",
                  "x-ms-summary": "documents"
                },
                ...
              }
            }
          }
        }
      }
    }
  },
  "definitions": {},
  "parameters": {},
  "responses": {},
  "securityDefinitions": {
     ...
    }
  },
  "security": [],
  "tags": []
}

then re-create a new custom connector based on your OpenAPI definition file, check if the issue is solved.

Please also check and see if the following thread would also help in your scenario:

https://powerusers.microsoft.com/t5/General-Discussion/How-do-I-bind-my-custom-API-to-a-dropdown-con...

 

Best regards,

Kris

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Administrator
Administrator

Re: Connecting Custom API

Thanks for your help with this thread @timl and @v-xida-msft

 

@zdames if you're still receiving this error, can you review the information provided and reply in this thread?

 

@TopShelf-MSFT

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 283 members 4,828 guests
Please welcome our newest community members: