Getting 404 with dataset parameters on LInked REST API

Question

I am hitting a URL that I use parameters to vary my request. I've successfully got the URL working only if all of my if I hard-code all my parameters. The URL I'm hitting returns flight information for various airlines

My URL on the Linked Service is https://serveraddress/MQApi/api/v1/@linkedService().Method/@linkedService().Airline/@linkedService().FltDate/@linkedService().FltSet

When I do a copydata, it works if on my dataset, I hard code those paramenters. But if I attempt to use @dataset().FltDate (with dataset parameters) then it will fail. The caveat to that is that it does work for @dataset().FltSet (the last parameter on the URL). But changing any of the others to use @dataset parameters will create a 404 when I run it. I assume the URL may not be getting constructed properly, but I don't know of a way to see it to troubleshoot.

Answer 1

Hi @Chris Menegay ,

Welcome to Microsoft Q&A Platform. Thanks for posting the query.

I am able to reproduce it and I checked the previous similar issue details reported by Customers. Observed that this approach does not work but instead please use variable/parameter in linked service. If need to be dynamically set you can use variables instead of parameters as below. I tested this approach and it worked.

Variables created:

URL Formation:

Linked Service referring to variable

Hope this helps! Please let us know for further queries or if issue persists and we will be glad to assist.