1
0
-1
2 answers
- 210
Hi Ernest,
As Bastiana mentioned, you can only store a single value to the workflow variable. Looking at the SOAP call, the response is an array, so you can try using an index in the XML Object Name to reference the first element e.g.
GetAirportInformationByCountryResult.NewDataSet.Table[0].RunwayLengthFeet
- shaker alzoubi
The airport webservice url is not longer working; Need to know the structure of this URL Is the NewDataSet.Tabl part of the wsdl xml or a parametes to be used wherever. in any other processes
Add your comment... - 210
"Store to Workflow Variable" tab only expect one singular object value, it will not loop through multirow data of your airports.
It is not the same like iteration based support under "Store to Form" where it loops through and store multiple records in form data table.
Reference: SOAP Tool
Add your comment...
Hi Anders.
Hope you can help.
I have used the SOAP Tool sample app (using the airport service), and added a tool event (LogData), after the "Show Data" activity as per screenshot below:
I have added a workflow variable "RunwayLengthFeet"
I have mapped this workflow variable ("RunwayLengthFeet") to the XML object name "GetAirportInformationByCountryResult.NewDataSet.Table.RunwayLengthFeet" in the SOAP Tool as per the screenshot below:
In the "LogData" tool event, i used the Database Update Tool mapped to (LogData), to log the value of my workflow variable ("RunwayLengthFeet"), that i have created in the process. below is my SQL INSERT Query:
INSERT INTO [dbo].[LogWFParameter]
(
ParameterName,
[TimeStamp]
)
VALUES
(
'#variable.RunwayLengthFeet#',
GetDate()
)
However, this workflow variable ("RunwayLengthFeet"), is never populated, as the value in the database reflects empty string as per SQL table results below:
Could you kindly please advise?
Thanks for your help, i really appreciate it.
Ernest.