Custom Connector issue

[Manarjomar]

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:

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.

[summitb · Accepted solution]

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

[Manarjomar · Accepted solution]

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.

[summitb]

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