ahaaften
Nintex Newbie

Executing a web request control in Nintex Forms

Hi, we're using a document filing system with an MDR for unique document number tracking. I'm looking into building a control on the Nintex Form to display existing documents with the same 'document identifiers'.

 

I tried to accomplish this with a list lookup control, but I can't input a wildcard as a filter value. In a web request I should be able to execute a query with a "StartsWith" parameter, like the a "Query list" action in Workflow.

 

This example shows 2 existing documents starting with the same 'document identifiers'.

2020-09-30_102516.png

 

I've copied the query to the web request and filled all the required fields and I'm getting similar results:

2020-09-30_105313.png

Result:

2020-09-30_110159.png

I need help forming a XPath expression to extract only the document numbers, so I can present them as "option buttons".

 

Full XML output:

 

 

<?xml version="1.0" encoding="utf-8"?><soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"><soap:Body><GetListItemsResponse xmlns="http://schemas.microsoft.com/sharepoint/soap/"><GetListItemsResult><listitems xmlns:s='uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882'
     xmlns:dt='uuid:C2F41010-65B3-11d1-A29F-00AA00C14882'
     xmlns:rs='urn:schemas-microsoft-com:rowset'
     xmlns:z='#RowsetSchema'>
<rs:data ItemCount="2">
   <z:row ows_Document_x0020_number='PI-13006-999-A-Q-001 Rev B.txt' ows_MetaInfo='34753;#WorkflowCreationPath:SW|32b84759-98d1-4a7e-9004-1771ca690cc3;&#13;&#10;' ows__ModerationStatus='0' ows__Level='1' ows_Title='Test nieuw formulier as built (TWT)' ows_ID='34753' ows_UniqueId='34753;#{C84D0507-B535-46B4-8D13-7DBBD3407B0D}' ows_owshiddenversion='4' ows_FSObjType='34753;#0' ows_Created='2020-09-30 15:49:43' ows_PermMask='0x7fffffffffffffff' ows_Modified='2020-09-30 18:23:45' ows_FileRef='34753;#Lists/mdr/34753_.000' />
   <z:row ows_Document_x0020_number='PI-13006-999-A-Q-001 Rev A.jpg' ows_MetaInfo='34754;#WorkflowCreationPath:SW|32b84759-98d1-4a7e-9004-1771ca690cc3;&#13;&#10;' ows__ModerationStatus='0' ows__Level='1' ows_Title='Test current (No3)' ows_ID='34754' ows_UniqueId='34754;#{2293AFD8-C502-42B7-8F07-34BC1710BAB3}' ows_owshiddenversion='1' ows_FSObjType='34754;#0' ows_Created='2020-09-30 15:49:43' ows_PermMask='0x7fffffffffffffff' ows_Modified='2020-09-30 15:49:43' ows_FileRef='34754;#Lists/mdr/34754_.000' />
</rs:data>
</listitems></GetListItemsResult></GetListItemsResponse></soap:Body></soap:Envelope>

 

 

 

Thank you.

0 Kudos
Reply
1 Reply
SimonMuntz
Nintex Employee
Nintex Employee

Re: Executing a web request control in Nintex Forms

Hi,

What happens if you use
/soap:Envelope/soap:Body/defaultNS:GetListItemsResponse/defaultNS:GetListItemsResult/defaultNS:listitems/rs:data/z:row/@ows_Document_x0020_number
0 Kudos
Reply