Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am generating a SOAP data load to a web service using a REST connector. I have an XML code where I include certain parameters that allow me to retrieve the data. One of those parameters is the start date and end date. I am looking for a way to make that date dynamic, so that it doesn't have to be manually updated every month. Does anyone know how I can achieve this?
I am attaching images of how it is being generated
RestConnectorMasterTable:
SQL SELECT
"__KEY_Envelope",
(SELECT
(SELECT
"ConsultaNominaResult",
"__FK_ConsultaNominaResponse"
FROM "ConsultaNominaResponse" FK "__FK_ConsultaNominaResponse")
FROM "Body" PK "__KEY_Body" FK "__FK_Body")
FROM XML "Envelope" PK "__KEY_Envelope";
<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
<soap:Body>
<ConsultaNomina xmlns="http://tempuri.org/">
<Usuario>string</Usuario>
<Password>string</Password>
<Token>string</Token>
<Empresa_ID>int</Empresa_ID>
<DatosConsulta>{"RegPat_ID":1,"Centro_ID":"*","Periodo_ID":"1","Trab_ID":"*","FechaInicio":"01/10/2023","FechaFin":"31/10/2023","Concepto_ID": "*", "TipoNomina_ID":1}</DatosConsulta>
</ConsultaNomina>
</soap:Body>
</soap:Envelope>
I have tried generating variables and adding them to the body header, but it has not worked. I don't know what else to do. Does anyone have any ideas or if they have done it before?
I will be attentive to your comments
you can made this field as variables and be added in your load script
see the sample here:
REST connector: How to modify queryt URL, Paramete... - Qlik Community - 1713483