Forum Discussion

Garrett's avatar
Garrett
New Contributor II
5 years ago

API query invalid in SnapLogic, but valid in Postman

Split out from: 401 Error using Https in API REST GET call Did you ever solve your issue? I am experiencing something similar. To answer the question the User-Agent can be anything. Somethi...
ptaylor's avatar
ptaylor
Employee
5 years ago

It is not necessary to use encodeURIComponent. The REST Get snap will properly encode the query parameter values. Can you please show the full configuration of your REST Get snap?

ptaylor's avatar
ptaylor
Employee
5 years ago

I also have to say that providing a REST service which accepts a SQL command to execute against your database seems like a rather significant security vulnerability.

  • Garrett's avatar
    Garrett
    New Contributor II
    5 years ago

    It is not SQL. It is Oracle’s proprietary language ROQL.

    I am not sure how to send you the configuration.

    • ptaylor's avatar
      ptaylor
      Employee
      5 years ago

      Post a screenshot of the REST Get settings.

      • ptaylor's avatar
        ptaylor
        Employee
        5 years ago

        Let me clarify what would help us help you. You said you tried making a query with Postman which worked, but you tried making the same query with REST Get which didn’t work. Please post a screenshot of both showing the full configuration.