API with relative path

[AlexisPREVOT]

Hello,

I want to call an API that feeds me information following cells in a table using a relative path.

Here is my API call :

let
apiURL = "https://api.insee.fr/entreprises/sirene/V3/siret/",

options = [Headers=[Authorization="Bearer XXXXXXXX", ConsumerKey="XXXXXXXXXX", ConsumerSecret="XXXXXX", Accept="application/json"], RelativePath = #"ENTREPRISES"[SIRET]],

resultat = Json.Document(Web.Contents(apiURL,options))

in
resultat

I wish to have a final URL as well : https://api.insee.fr/entreprises/sirene/V3/siret/{"ENTREPRISES"[SIRET]}

My concern is that when I want to launch the call I have the following error message: 

Expression.Error : Sorry ... We were unable to convert a value of type List to type Text.
Détails :
Value=[List]
Type=[Type]

How can I solve this problem please ?

Thanks in advance

Alexis

[v-yingjl · Accepted solution]

Hi @AlexisPREVOT ,

In your RelativePath value, #"ENTREPRISES"[SIRET] returns a whole list not a specific text value so it occurs the convert error.

If you want to quote a specific text value from the list to use it as RelativePath, you can write like this:

#"ENTREPRISES"[SIRET]{0}   // 0 means that it extracts the first value in this list and so on

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[AlexisPREVOT]

Hi @v-yingjl,

Thank you for the answeer, it works.

Best regards