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

Announcements
Join us in Bucharest on Sept 18th 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.