AnsweredAssumed Answered

SQL query in request body

Question asked by cyoes858743 on Nov 7, 2017
Latest reply on Nov 8, 2017 by Sjaak Overgaauw

I am attempting to query our StarRez database using their REST API. The StarRez documentation says they recommend sending the data within the request body (POST) as XML. I have been able to do this successfully via Postman, but I am struggling to make it work in Boomi.

 

I have read the Boomi Community documents on "How to Build a POST Request for a REST Endpoint," and "How do I put URL encoded data in the BODY of a POST request," but neither of these use cases exactly mirror what I am trying to do.

 

The request body data I need to send is a SQL query such as

SELECT Booking.BookingID,
RoomLocation.CustomString1
from Booking
JOIN TermSession ON Booking.TermSessionID = TermSession.TermSessionID
JOIN RoomLocation ON Booking.RoomLocationID = RoomLocation.RoomLocationID
WHERE TermSession.TermSessionID = ?

Outcomes