To retrieve certain data, we use an API. The endpoint consists of a template because a specific code needs to be included in the URL. The problem is that the template accesses the URL and then uses that result in the endpoint field.
In the image above, the URL is shown. A code should appear in place of the *. However, the URL is apparently being requested, resulting in this outcome:
Not sure I understand, but the template column is not requesting the url. As far as the template column is concerned, it’s just building text. You are replacing * with a JSON object, so the result is the url with the JSON object inserted into it. What does the column look like that you are using for the replacement of *?
The * is a code (in this case, 0268100000028624). It is inserted into the URL using the template, so https://public.ep-online.nl/api/v5/PandEnergielabel/AdresseerbaarObject/*/ becomes https://public.ep-online.nl/api/v5/PandEnergielabel/AdresseerbaarObject/0268100000028624/.
Because the template column displays the resulting URL, I cannot use the constructed URL in the API.
So the template generates this link (The result of the link is not the data we need):