Announcement

Collapse
No announcement yet.

Help Sending a SQL Query to OTM through HTTP POST using sql2xml

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Help Sending a SQL Query to OTM through HTTP POST using sql2xml

    Hi, i'm trying to send a sql query through HTTP POST, but the answer from OTM asks for one of these:

    <ERROR>Specify one of -entityName, -dbObjectName, -sqlQuery, -sqlFile, or -dbObjectSetName</ERROR>

    Printscreen of POSTMAN app attached.

    How do I send this information through HTTP POST? is this a parameter?

    I have successfully sent the same query through SOAP and it works very well but, its so verbose and i prefer the http post alternative, does anyone knows how to send this -sqlQuery parameter?

    Thiago

  • #2
    I found the "solution"

    we need to send the sqlQuery parameter in the url with the command itself, what does not make ANY sense, because it should be a POST request, also, we don't need to send anyting on POST body request, as image attached follows...

    ​​​​​​​

    Comment

    Working...
    X