cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Manarjomar
Resolver I
Resolver I

Custom Connector issue

Hi all,

 

I've been trying for three days to get a custom connector to work on PowerApps.

 

The connector is for the historical endpoint API on:

api.currencyscoop.com

 (it's a free API to get currencies exchange rates).

 

The conector work fine on the builder (I get the answer) but I can get the answer on PowerApps.

 

I think the error could be on the schema body answer, but I'm not sure how I can fix it.

 

This is the body answer on custom connector builder:

 

 

{
  "meta": {
    "code": 200,
    "disclaimer": "Usage subject to terms: https://currencyscoop.com/terms"
  },
  "response": {
    "date": "2020-10-29",
    "base": "USD",
    "rates": {
      "EUR": 0.85572621
    }
  }
}

 

 

 

 

I tried don't write on this screen:

 

 

Screenshot_1.pngScreenshot_3.png

 

But in PowerApps formula I can't get answer (don't show error but is blank), so I thought that maybe is needed write an schema to get the outputs, and I tried with this one:

 

 

{"response": {
"properties": {
"rates": {
"EUR": {
"value": "string"
}
}
}
}
}

 

But I have the same blank field on PowerApps with this formula:

CambioDivisa.Run(
    {
        api_key: "heretheapikey";
        base: DataCardValue52.Text;
        date: Text(
            DataCardValue33.SelectedDate;
            "[$-es-ES]yyyy-mm-dd"
        );
        symbols: "EUR"
    }
).response.properties.rates.EUR.value

 

I would prefer don't specific the "EUR" string to can use anyone, but now I'm lost and I don't know how can fix it.

 

Any idea will wellcome.

 

Thank you.

2 ACCEPTED SOLUTIONS

Accepted Solutions
summitb
Power Participant
Power Participant

It worked for me. I have exported the connector have a look.

 

Capture.JPG

View solution in original post

Hi @summitb ,

 

Your solution is not exackly I'm looking for but it gave me the best help to get it.

 

Your endpoint is for the "latest" value and my question was for the "historical", but I use your code to get my connector (attached the code to help others).

 

Many thanks.

View solution in original post

3 REPLIES 3
summitb
Power Participant
Power Participant

It worked for me. I have exported the connector have a look.

 

Capture.JPG

View solution in original post

Hi @summitb ,

 

Your solution is not exackly I'm looking for but it gave me the best help to get it.

 

Your endpoint is for the "latest" value and my question was for the "historical", but I use your code to get my connector (attached the code to help others).

 

Many thanks.

View solution in original post

Sorry for that. I am glad that it helped though. Cheers!

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Users online (932)