Skip to main content
November 17, 2021
Solved

Can I use DQL query in Integration url?

  • November 17, 2021
  • 12 replies
  • 0 views

I want to use one get API endpoint which has dql query in the endpoint. but its failing in Appian integration and getting result from postman.

1. When I execute Get API endpoint in postman am getting result. but if i do the same in appian Integration am getting error.

what might be the reason? Do integration doesnt support dql query?

    Best answer by stefanhelzle0001

    The images are too small. I can not see anything.

    I think the important part is, that you do not just put the whole URL into the URL field, but just the base URL

    https://api.medstest.merck.com/d2rest/repositories/medstst

    Then create a query parameter named "dql" and put the query in it. Appian will then do all the escaping for you.

    12 replies

    stefanhelzle0001
    Brainy
    November 17, 2021

    DQL is just the query string in the URL you are calling. There is no need for any kind of support. But you might need to URL encode it. Can you post a screenshot of your integration?

    November 17, 2021

    Hi Stefan,

    for equals i have used %3d but am not sue what i must use for single quotes present in the dql query

    stefanhelzle0001
    Brainy
    November 17, 2021

    The images are too small. I can not see anything.

    I think the important part is, that you do not just put the whole URL into the URL field, but just the base URL

    https://api.medstest.merck.com/d2rest/repositories/medstst

    Then create a query parameter named "dql" and put the query in it. Appian will then do all the escaping for you.