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
JOIN TermSession ON Booking.TermSessionID = TermSession.TermSessionID
JOIN RoomLocation ON Booking.RoomLocationID = RoomLocation.RoomLocationID
WHERE TermSession.TermSessionID = ?