Skip to main content
Participating Frequently
Nov 17, 2021 9:54 AM UTC
Solved

Can I use DQL query in Integration url?

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?

    stefanhelzle0001
    Brainy
    Nov 17, 2021 3:43 PM UTC

    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
    Nov 17, 2021 11:07 AM UTC

    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?

    Participating Frequently
    Nov 17, 2021 2:48 PM UTC

    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
    Nov 17, 2021 3:43 PM UTC

    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.