REST Query results in data provider

[kasgithub8]

Hi all,

is there a way to use the results of a REST Query in a data provider?

My query:
https://api.cognitive.microsofttranslator.com/languages?api-version=3.0&scope=translation

Sincerely,
Kevin

[ConorWebb96]

Hey @kasgithub8,

If you use the rest connector and import the above query you can then send and save. From here you should then be able to select this query to be used inside a data provider.

Hopefully this helps.

[kasgithub8]

Right, that's how far I got.
The result is the usual [object Object] and when I try to use it in a options picker there's only one available field, "translation" which is the array outside of the answers I want to use.

[ConorWebb96]

The array you are trying to use is structured in a weird way. Its not a normal occurrence for object keys to be named. To get this to work in a select, all you would need to do is create a new array that only outputs the object key names. Then return this newly structured array which should now be suitable to be used in the multi-select component.

Transformer js here

const languageCodesArray = Object.keys(data.translation);

return languageCodesArray;

Heres screenshots of this process.

[kasgithub8]

@ConorWebb96 ah! That's a cool use case for the transformer. And yes, the array is weirdly structured like that because it's Microsoft 😄.
My end goal is to translate text with this query: https://api.cognitive.microsofttranslator.com/translate?api-version=3.0&from=de&to=bg.

Now my problem is that the Microsoft API only accepts the content-type: application/JSON.
When I fill the body with raw(JSON) [ {"text": "Hey, what's your name?"} ] it works as expected. But you can't use the input of a text field because it's just raw JSON without any bindings.
Do you know anything about that?

[kasgithub8]

Got it myself!