Is it possible to pass parameters (query string) in a Web API request ?

Posted by: harold.saavedra on 16 August 2020, 1:18 pm EST

  • Posted 16 August 2020, 1:18 pm EST

    Reference: https://stackoverflow.com/questions/63392884/in-activereportsjs-is-it-possible-to-pass-parameters-to-a-web-service

    I'm trying to get the DataSource from a web server API and I want to pass parameters to the API as a query string.

    I'm using the Content URI to call the API but I'm not able to put the report parameters into the query string:

    I have tried something like:
    http://northwind.netcore.io/customers?format=Parameters!Parameter1.value

    but it doesn't work.

    Is it possible to set parameters in the Content URI when calling an API ?
  • Marked as Answer

    Replied 16 August 2020, 8:07 pm EST

    Hello,

    Have you tried with the following connection strings:
    ="jsondoc=" & "http://northwind.netcore.io/customers?format=" &Parameters!Parameter1.Value

    Also, to create fields automatically, You can do one thing, create datasource and dataset with valid data and bind the table with the dataset. After that, you can just replace connection string in the connection string with the above one:

    Thanks,
    Mohit
  • Replied 17 August 2020, 1:25 pm EST

    Hello Mohit,

    Thank you for your help.
    I was able to pass the query parameters using the Connection String text area.
    It is confusing that the "Content URI" has to be empty and the "Connection String" has to be set though.
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels