The connection is successful as I'm getting data (specifically a login ticket) from the web service I'm connecting to, and Qlik correctly interprets this as XML data.
Now to the actual problem:
When I query the web service for actual data (from the General Ledger etc), the response body is pretty big, and there is no built-in method of pagination to use with the web service. When I try the query in Postman, the response gives me the whole response body and it is successful.
When I try the query in the Qlik Sense script it looks like this:
RestConnectorMasterTable: SQL SELECT "__KEY_Envelope", (SELECT "__KEY_Body", "__FK_Body", (SELECT "GetGeneralLedgerDataResult", "__FK_GetGeneralLedgerDataResponse" FROM "GetGeneralLedgerDataResponse" FK "__FK_GetGeneralLedgerDataResponse") FROM "Body" PK "__KEY_Body" FK "__FK_Body") FROM XML "Envelope" PK "__KEY_Envelope" WITH CONNECTION ( BODY "$(vRequestBodyGetGeneralLedgerData)" );
When I load the GetGeneralLedgerDataResponse in a table, I get this single message stored in a field in the loaded table:
"Error: Failed to fill DataSet, , Object reference not set to an instance of an object.,".
It seems that the xml body response can't be parsed correctly, as if it tries to store the entire response in a single cell in the table.