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

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.

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

Helpful resources

Announcements
Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (1,626)