Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
ArielNF
Partner - Contributor
Partner - Contributor

How can I generate a SOAP data load dynamically?

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

ArielNF_0-1703617427254.png

 

 

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";

 

 

ArielNF_1-1703617534469.png

ArielNF_3-1703617684308.png

ArielNF_4-1703617757483.png

 

 

<?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

1 Reply
TcnCunha_M
Creator III
Creator III

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

 

 

As you think, so shall you become.