GetDynamicQuery
|
Initial Build |
2006.02 |
|
xWEB |
Web Method |
|
Response Type |
XML Node |
This web method retrieves data from a Query that was built using the NetForum query feature in iWeb. Queries are available for an xWeb User to run based on Query Security.
This web method returns the results of a Query in an XmlNode format. This is essentially an XML version of the iWeb Query Tool.
In general use, the integrating program may need to call this method once to get a list of all the queries for a particular object, and then a second time to get the response for a specific query. Alternately, if you have a specific query in mind, then you can skip the first step and just run the web method for the particular query.
Parameters
You must pass the combination of szObjectName and szQueryName because this combination ensures uniqueness. The szQueryName cannot be duplicated within the same szObjectName, but the query name may be duplicated with another object.
In other words, you may only have one query called Full Members in the Individual object, but you may have that same query in the Membership object.
- szObjectName (string). Name of Facade Object. See XWeb:GetFacadeObjectList#Object_Name for more direction on this parameter.
- szQueryName (string). Leave empty to get list of all queries, or pass the query name of a specific query to get the results for that query.
- WithDescriptions (string). Leave empty for default behavior. Pass value of "1" if you want column descriptions to be returned instead of column names.
- currentPage (int). - See #Pagination. This parameter was introduced in 2011.01.
Response
This method returns an XML node, based on the query submitted.
Usage
o.GetDynamicQuery (szObjectName as string,szQueryName as string, WithDescriptions as string) as XmlNode
Sample Request
This is a request to get all the queries for the Individual object. By leaving szQueryName empty, this instructs the web method to return a list of all queries.
<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<SOAP-ENV:Header>
<m:AuthorizationToken xmlns:m="http://www.avectra.com/2005/">
<m:Token>796b4588-b46b-4fe2-9b64-0600c007c700</m:Token>
</m:AuthorizationToken>
</SOAP-ENV:Header>
<SOAP-ENV:Body>
<m:GetDynamicQuery xmlns:m="http://www.avectra.com/2005/">
<m:szObjectName>Individual</m:szObjectName>
<m:szQueryName></m:szQueryName>
<m:WithDescriptions></m:WithDescriptions>
</m:GetDynamicQuery>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>
Sample Response
This is a response to the request above, showing a list of all the queries for the Individual object. You will want to look at the value of que_description as you will need to pass it to szQueryName in a subsequent web method call.
<?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" xmlns:wsa="http://schemas.xmlsoap.org/ws/2004/03/addressing" xmlns:wsse="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd" xmlns:wsu="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd">
<soap:Header>
<AuthorizationToken xmlns="http://www.avectra.com/2005/">
<Token>cd81b97c-ecb2-41dc-a277-76c34b161246</Token>
</AuthorizationToken>
<wsa:Action>http://www.avectra.com/2005/GetDynamicQueryResponse</wsa:Action>
<wsa:MessageID>uuid:6c861b8a-1276-4d0d-9aed-973be730d0d4</wsa:MessageID>
<wsa:RelatesTo>uuid:8c38c823-1a26-4af9-9a77-5cc141aba54a</wsa:RelatesTo>
<wsa:To>http://schemas.xmlsoap.org/ws/2004/03/addressing/role/anonymous</wsa:To>
<wsse:Security>
<wsu:Timestamp wsu:Id="Timestamp-6c93e1a5-9fe7-43ee-986d-8e2af63085b2">
<wsu:Created>2006-09-25T19:55:17Z</wsu:Created>
<wsu:Expires>2006-09-25T20:00:17Z</wsu:Expires>
</wsu:Timestamp>
</wsse:Security>
</soap:Header>
<soap:Body>
<GetDynamicQueryResponse xmlns="http://www.avectra.com/2005/">
<GetDynamicQueryResult>
<Results recordReturn="69">
<Result>
<que_key>b853b382-0296-47fd-af0f-d15d52917acf</que_key>
<que_description>**Missing Congress District</que_description>
</Result>
<Result>
<que_key>1fc5f99f-de4f-4875-ac0c-fb7ef6d9091e</que_key>
<que_description>**Non-Members Receiving Inherited Membership Benefits</que_description>
</Result>
<Result>
<que_key>edd3f074-c9eb-4244-b2ab-144d6a52c5c0</que_key>
<que_description>*normalquery</que_description>
</Result>
<Result>
<que_key>292ba88a-2abd-435d-863e-6c5b147e1fb1</que_key>
<que_description>_Silviu's test</que_description>
</Result>
<Result>
<que_key>7422f6a5-7eb1-4369-b265-ac61c9a84290</que_key>
<que_description>391 records</que_description>
</Result>
<Result>
<que_key>5ef73225-83b6-43b9-855c-93e5f26f0d38</que_key>
<que_description>AliTestSQL</que_description>
</Result>
</Results>
</GetDynamicQueryResult>
</GetDynamicQueryResponse>
</soap:Body>
</soap:Envelope>
Request for Specific Query
This is a request to get the results of a single query, with the query name passed in the szQueryName parameter. You will know the value of szQueryName based on the value of que_description returned in the response example above:
<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<SOAP-ENV:Header>
<m:AuthorizationToken xmlns:m="http://www.avectra.com/2005/">
<m:Token>cd81b97c-ecb2-41dc-a277-76c34b161246</m:Token>
</m:AuthorizationToken>
</SOAP-ENV:Header>
<SOAP-ENV:Body>
<m:GetDynamicQuery xmlns:m="http://www.avectra.com/2005/">
<m:szObjectName>Individual</m:szObjectName>
<m:szQueryName>All National Members</m:szQueryName>
<m:WithDescriptions></m:WithDescriptions>
<m:currentPage>1</m:currentPage>
</m:GetDynamicQuery>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>
Response for Specific Query
Response, showing the actual data returned by the query:
<?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" xmlns:wsa="http://schemas.xmlsoap.org/ws/2004/03/addressing" xmlns:wsse="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd" xmlns:wsu="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd">
<soap:Header>
<AuthorizationToken xmlns="http://www.avectra.com/2005/">
<Token>7f21c422-b1da-4c6f-92ed-75bd44ca9d07</Token>
</AuthorizationToken>
<wsa:Action>http://www.avectra.com/2005/GetDynamicQueryResponse</wsa:Action>
<wsa:MessageID>uuid:43a3fdf6-feb6-45ac-abc9-001fe742a81a</wsa:MessageID>
<wsa:RelatesTo>uuid:944195cd-e44d-4ce4-8146-021c3a12c06e</wsa:RelatesTo>
<wsa:To>http://schemas.xmlsoap.org/ws/2004/03/addressing/role/anonymous</wsa:To>
<wsse:Security>
<wsu:Timestamp wsu:Id="Timestamp-e57868c2-e8c9-40cc-8547-8cd7c2019a3c">
<wsu:Created>2006-09-25T19:58:41Z</wsu:Created>
<wsu:Expires>2006-09-25T20:03:41Z</wsu:Expires>
</wsu:Timestamp>
</wsse:Security>
</soap:Header>
<soap:Body>
<GetDynamicQueryResponse xmlns="http://www.avectra.com/2005/">
<GetDynamicQueryResult>
<Results recordReturn="18" pageTotal="1" recordTotal="18">
<Result>
<ind_cst_key>f00353cc-1fa4-40ab-9ff6-008c2603fb21</ind_cst_key>
<ind_first_name>Gabriel</ind_first_name>
<ind_last_name>Reiser</ind_last_name>
<cst_org_name_dn>Avectra, Inc.</cst_org_name_dn>
<cst_eml_address_dn>greiser@avectra.com</cst_eml_address_dn>
<adr_line1>7601 Jones Branch Drive</adr_line1>
<adr_city_state_code>McLean, VA 22102</adr_city_state_code>
</Result>
<Result>
<ind_cst_key>e5d0c114-6ee0-4d1e-bcff-067297ba9402</ind_cst_key>
<ind_first_name>Olivia</ind_first_name>
<ind_last_name>Bilbyfive</ind_last_name>
<cst_org_name_dn>OLB Test Org 1</cst_org_name_dn>
<cst_eml_address_dn>obilby@avectra.com</cst_eml_address_dn>
<adr_line1>7901 Jones Branch Dr</adr_line1>
<adr_city_state_code>Mc Lean, VA 22102-3316</adr_city_state_code>
</Result>
<Result>
<ind_cst_key>5428b5e7-11e2-4e78-8345-08d1f6e174fc</ind_cst_key>
<ind_first_name>Raaj3</ind_first_name>
<ind_last_name>Jeeth</ind_last_name>
<cst_org_name_dn/>
<cst_eml_address_dn>rjeeth@avectra.com</cst_eml_address_dn>
<adr_line1>7901 jones branch dr</adr_line1>
<adr_city_state_code>,</adr_city_state_code>
</Result>
<Result>
<ind_cst_key>a67ced09-75ba-4340-8b4a-0c9d27ee1675</ind_cst_key>
<ind_first_name>ksrao41</ind_first_name>
<ind_last_name>katras</ind_last_name>
<cst_org_name_dn>ORG A</cst_org_name_dn>
<cst_eml_address_dn>skatragadda@avectra.com</cst_eml_address_dn>
<adr_line1>7901 Jones Drv</adr_line1>
<adr_city_state_code>mc lean, VA 21222</adr_city_state_code>
</Result>
<Result>
<ind_cst_key>9fdb7924-1f25-423f-ad94-1b06b54b4607</ind_cst_key>
<ind_first_name>John</ind_first_name>
<ind_last_name>Smith</ind_last_name>
<cst_org_name_dn>Oracle</cst_org_name_dn>
<cst_eml_address_dn>sdemirtoka3@avectra.com</cst_eml_address_dn>
<adr_line1>8901 Leesburg Pike</adr_line1>
<adr_city_state_code>Falls Church, VA 21222</adr_city_state_code>
</Result>
</Results>
</GetDynamicQueryResult>
</GetDynamicQueryResponse>
</soap:Body>
</soap:Envelope>
If you had passed the value "1" in WithDescription then the result would be like this instead:
<Result>
<PrimaryKey>d971773e-1d3a-46a6-9852-a739247a3b63</PrimaryKey>
<FirstName>ksrao39</FirstName>
<LastName>katra</LastName>
<OrganizationName>ORG A</OrganizationName>
<PrimaryE-Mail>sbandaru@avectra.com</PrimaryE-Mail>
<AddressLine1>7901 Jones Drv</AddressLine1>
<CityStatePostCode>Mc lean, VA 21222</CityStatePostCode>
</Result>
<Result>
<PrimaryKey>22e1d8cd-80b3-4f6a-aa4c-adfed491e804</PrimaryKey>
<FirstName>Timothy</FirstName>
<LastName>Ward</LastName>
<OrganizationName>Avectra, Inc.</OrganizationName>
<PrimaryE-Mail>tward@avectra.com</PrimaryE-Mail>
<AddressLine1>7901 Jones Branch Dr</AddressLine1>
<CityStatePostCode>Mc Lean, VA 22102</CityStatePostCode>
</Result>
Parameters Collection
Beginning with the 2007.01 build of netFORUM, GetDynamicQuery supports ask-at-runtime parameters. In earlier builds, only queries without runtime parameters will function with GetDynamicQuery.
A new XmlNode parameter called Parameters has been added. Each <Parameters/> contains one or more <Parameter/> nodes with a <Name/> and <Value/> element as shown below:
<?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:Header>
<AuthorizationToken xmlns="http://www.avectra.com/2005/">
<Token>string</Token>
</AuthorizationToken>
</soap:Header>
<soap:Body>
<GetDynamicQuery xmlns="http://www.avectra.com/2005/">
<szObjectName>string</szObjectName>
<szQueryName>string</szQueryName>
<WithDescriptions>string</WithDescriptions>
<Parameters>
<Parameter>
<Name>string</Name>
<Value>string</Value>
</Parameter>
<Parameter>
<Name>string</Name>
<Value>string</Value>
</Parameter>
</Parameters>
</GetDynamicQuery>
</soap:Body>
</soap:Envelope>
GetDynamicQuery Sample Request with Parameters
The Parameter/Name is combination of a guid, then an underscore character, and then an integer counter e.g. 40794c6e-a417-4c7c-859b-3bc580adbe5d_2. You can get the parameter names from the GetDynamicQueryDefinition web method response; see this page to get an understanding of how the parameters are named. The Parameter/Value will contain the value that you want to pass with that paramter.
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns="http://www.avectra.com/2005/">
<soapenv:Header>
<ns:AuthorizationToken>
<ns:Token>bdd60d7e-4637-4406-8610-42e76817c1c9</ns:Token>
</ns:AuthorizationToken>
</soapenv:Header>
<soapenv:Body>
<ns:GetDynamicQuery>
<ns:szObjectName>Individual</ns:szObjectName>
<ns:szQueryName>Individuals on Committee</ns:szQueryName>
<ns:WithDescription></ns:WithDescription>
<ns:Parameters>
<ns:Parameter>
<ns:Name>40794c6e-a417-4c7c-859b-3bc580adbe5d_2</ns:Name>
<ns:Value>A</ns:Value>
</ns:Parameter>
<ns:Parameter>
<ns:Name>bbcdb8c8-3811-4f6b-9549-4b92badeda9b_0</ns:Name>
<ns:Value>b9ae781c-b9c1-4636-a05c-f61835be49c2</ns:Value>
</ns:Parameter>
<ns:Parameter>
<ns:Name>e6b7af49-eb96-4db3-875e-9eef859d1d31_1</ns:Name>
<ns:Value>72db64c1-63d2-4f70-88cb-cc38003e0beb</ns:Value>
</ns:Parameter>
<ns:Parameter>
<ns:Name>40794c6e-a417-4c7c-859b-3bc580adbe5d_3</ns:Name>
<ns:Value>01/01/2007</ns:Value>
</ns:Parameter>
</ns:Parameters>
</ns:GetDynamicQuery>
</soapenv:Body>
</soapenv:Envelope>
GetDynamicQuery Response With Parameters
Here is the response for GetDynamicQuery. It is no different from the way the method works currently. Whether or not the underlying query does or does not have ask-at-runtime parameters is irrelevant.
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<soap:Header>
<AuthorizationToken xmlns="http://www.avectra.com/2005/">
<Token>fd55a4e0-9a9b-4cb9-86e9-44ffa7ff284e</Token>
</AuthorizationToken>
</soap:Header>
<soap:Body>
<GetDynamicQueryResponse xmlns="http://www.avectra.com/2005/">
<GetDynamicQueryResult>
<Results recordReturn="1">
<Result>
<ind_cst_key>04a67c96-c280-42f4-a2ba-2291290f027d</ind_cst_key>
<ind_first_name>sr_tester1</ind_first_name>
<ind_last_name>av</ind_last_name>
<ind_sfx_code/>
</Result>
</Results>
</GetDynamicQueryResult>
</GetDynamicQueryResponse>
</soap:Body>
</soap:Envelope>
JSON Method
POST /xWeb/JSON/GetDynamicQuery
Copy
DATA: JSON
{
"GetDynamicQuery" : {
"szObjectName" : "individual",
"szQueryName" : "**Primary Contacts",
"WithDescriptions" : "",
"Parameters" : [],
"currentPage" : "0"
}
}
Copy
SAMPLE RESULT
HTTP STATUS: 200
DATA: JSON
{
"Results": {
"@recordReturn": "70",
"Result": [
{
"ind_last_name": "1",
"ind_first_name": "Test",
"ind_mid_name": null,
"cst_org_name_dn": null,
"cst_eml_address_dn": null,
"adr_line1": "Adr 1",
"adr_city_state_code": "C1, KS 11021",
"cst_no_email_flag": "0"
},
{
"ind_last_name": "A",
"ind_first_name": "Jerry",
"ind_mid_name": null,
"cst_org_name_dn": "AA",
"cst_eml_address_dn": "tomjerry@cm.com",
"adr_line1": "2647 Thompson Drive",
"adr_city_state_code": "Arkansas, AR 72212",
"cst_no_email_flag": "0"
},
{
"ind_last_name": "Acame",
"ind_first_name": "Bob",
"ind_mid_name": null,
"cst_org_name_dn": null,
"cst_eml_address_dn": null,
"adr_line1": "2312 sunny rd",
"adr_city_state_code": "mclean, VA 22102",
"cst_no_email_flag": "0"
},
{
"ind_last_name": "Adams",
"ind_first_name": "Robert",
"ind_mid_name": null,
"cst_org_name_dn": "Acme Systems1adKSe",
"cst_eml_address_dn": "test220@yopmail.com",
"adr_line1": "4685 Hillview Drive",
"adr_city_state_code": "JOHNSON CITY, NY 78636",
"cst_no_email_flag": "0"
},
{
"ind_last_name": "Address",
"ind_first_name": "PRavin",
"ind_mid_name": "K",
"cst_org_name_dn": "Community Brands",
"cst_eml_address_dn": null,
"adr_line1": "1245 Alpine Avenue",
"adr_city_state_code": "Boulder, CO 80304",
"cst_no_email_flag": "0"
},
{
"ind_last_name": "Alberta2",
"ind_first_name": "blue3",
"ind_mid_name": null,
"cst_org_name_dn": "Apple",
"cst_eml_address_dn": "gilberto1112@gmail.com",
"adr_line1": "444 Golf Course444 Ln",
"adr_city_state_code": "Ellsworth, WI 54011",
"cst_no_email_flag": "0"
},
{
"ind_last_name": "Alvarez",
"ind_first_name": "Beverly",
"ind_mid_name": "Sally",
"cst_org_name_dn": "DELL Vendor",
"cst_eml_address_dn": "Alvarez.B@gmail.com",
"adr_line1": "7716 E. Virginia Drive",
"adr_city_state_code": "Madisonville, ID 42431",
"cst_no_email_flag": "0"
},
{
"ind_last_name": "Applegate",
"ind_first_name": "Eddy",
"ind_mid_name": null,
"cst_org_name_dn": null,
"cst_eml_address_dn": null,
"adr_line1": "400 Poydras ST Ste 900",
"adr_city_state_code": "New Orleans, VA 70130",
"cst_no_email_flag": "0"
},
{
"ind_last_name": "Baad",
"ind_first_name": "Nikhil",
"ind_mid_name": null,
"cst_org_name_dn": null,
"cst_eml_address_dn": "nik@gmail.com",
"adr_line1": "Lakeshire drive st 109",
"adr_city_state_code": "Dublin, OH 20101",
"cst_no_email_flag": "0"
},
{
"ind_last_name": "Beck",
"ind_first_name": "Traci",
"ind_mid_name": null,
"cst_org_name_dn": "DELL Company",
"cst_eml_address_dn": "zzpaula.wilson@communitybrands.comzz",
"adr_line1": "92 Jackson Drive",
"adr_city_state_code": "Mcminnville, NY 14092",
"cst_no_email_flag": "0"
},
{
"ind_last_name": "Bose",
"ind_first_name": "Akshay",
"ind_mid_name": null,
"cst_org_name_dn": "ABC Corporation Ltd",
"cst_eml_address_dn": "jjj.jjj@jjj.com",
"adr_line1": "374 William S Canning Blvd",
"adr_city_state_code": "Fall River, MA 02721",
"cst_no_email_flag": "0"
},
{
"ind_last_name": "Brooks",
"ind_first_name": "Paul",
"ind_mid_name": null,
"cst_org_name_dn": null,
"cst_eml_address_dn": "zzpaulb@mail.comzz",
"adr_line1": "333 N Dearborn ST",
"adr_city_state_code": "Chicago, IL 60654-4956",
"cst_no_email_flag": "0"
},
{
"ind_last_name": "Brown",
"ind_first_name": "Jesse",
"ind_mid_name": null,
"cst_org_name_dn": "Abila Organization",
"cst_eml_address_dn": null,
"adr_line1": "333 N Dearborn ST",
"adr_city_state_code": "Chicago, IL 60654-4956",
"cst_no_email_flag": "0"
},
{
"ind_last_name": "Buffett",
"ind_first_name": "Eric",
"ind_mid_name": null,
"cst_org_name_dn": null,
"cst_eml_address_dn": null,
"adr_line1": "4 Pleasant St",
"adr_city_state_code": "Boston, MA 02119",
"cst_no_email_flag": "0"
},
{
"ind_last_name": "CC",
"ind_first_name": "Pooja",
"ind_mid_name": null,
"cst_org_name_dn": "Pooja Org Testing",
"cst_eml_address_dn": "pooja.rakate@communitybrands.com",
"adr_line1": "2647 Thompson Drive",
"adr_city_state_code": "Arkansas, AR 72212",
"cst_no_email_flag": "0"
},
{
"ind_last_name": "Churchil",
"ind_first_name": "Novak",
"ind_mid_name": null,
"cst_org_name_dn": "Sept Organization",
"cst_eml_address_dn": "novakc@yopmail.com",
"adr_line1": "909 Aviation Pkwy",
"adr_city_state_code": "New York, NY 54260",
"cst_no_email_flag": "0"
},
{
"ind_last_name": "Clerk",
"ind_first_name": "Adam",
"ind_mid_name": null,
"cst_org_name_dn": "PD 137084",
"cst_eml_address_dn": "Adamc@yopmail.com",
"adr_line1": "909 Aviation Pkwy",
"adr_city_state_code": "New York, NY 54260",
"cst_no_email_flag": "0"
},
{
"ind_last_name": "Conversion",
"ind_first_name": "NFE",
"ind_mid_name": "Idea",
"cst_org_name_dn": null,
"cst_eml_address_dn": null,
"adr_line1": "2020 Quinte St.",
"adr_city_state_code": "Burlington, ON L7L7B6",
"cst_no_email_flag": "0"
},
{
"ind_last_name": "Cook",
"ind_first_name": "Tracy",
"ind_mid_name": null,
"cst_org_name_dn": null,
"cst_eml_address_dn": "zztracyc@mail.comzz",
"adr_line1": "10324 POE DR",
"adr_city_state_code": "MANASSAS, VA 20110",
"cst_no_email_flag": "0"
},
{
"ind_last_name": "Cooper",
"ind_first_name": "John",
"ind_mid_name": null,
"cst_org_name_dn": null,
"cst_eml_address_dn": null,
"adr_line1": "20628 Long Beach Dr",
"adr_city_state_code": "Millsboro, DE 19966",
"cst_no_email_flag": "0"
},
{
"ind_last_name": "David",
"ind_first_name": "Susan",
"ind_mid_name": null,
"cst_org_name_dn": "org21",
"cst_eml_address_dn": "mayank.sisodia@communitybrands.comqw",
"adr_line1": "3885 Brooke Street",
"adr_city_state_code": "Sugar Land, TX 77478",
"cst_no_email_flag": "0"
},
{
"ind_last_name": "Decker",
"ind_first_name": "Connor",
"ind_mid_name": null,
"cst_org_name_dn": null,
"cst_eml_address_dn": "zzconnord@mail.comzz",
"adr_line1": null,
"adr_city_state_code": null,
"cst_no_email_flag": "0"
},
{
"ind_last_name": "Decker",
"ind_first_name": "Stanley",
"ind_mid_name": null,
"cst_org_name_dn": "Black & Decker",
"cst_eml_address_dn": "zzsdecker@mail.comzz",
"adr_line1": "701 E Joppa Rd",
"adr_city_state_code": "Towson, MD 21286",
"cst_no_email_flag": "0"
},
{
"ind_last_name": "Evans",
"ind_first_name": "Bob",
"ind_mid_name": null,
"cst_org_name_dn": null,
"cst_eml_address_dn": null,
"adr_line1": "2134 Sleepy Hollow Ct",
"adr_city_state_code": "Vienna, VA 22108",
"cst_no_email_flag": "0"
},
{
"ind_last_name": "Fussell",
"ind_first_name": "Tracy",
"ind_mid_name": null,
"cst_org_name_dn": "TracTech Inc",
"cst_eml_address_dn": "tracy.fussell@abila.com",
"adr_line1": "10324 POE DR",
"adr_city_state_code": "MANASSAS, VA 20110-6146",
"cst_no_email_flag": "0"
},
{
"ind_last_name": "Fussell-Cook",
"ind_first_name": "Tracy",
"ind_mid_name": null,
"cst_org_name_dn": null,
"cst_eml_address_dn": null,
"adr_line1": "10324 POE DR",
"adr_city_state_code": "MANASSAS, VA 20110-6146",
"cst_no_email_flag": "0"
},
{
"ind_last_name": "Green",
"ind_first_name": "Tom",
"ind_mid_name": null,
"cst_org_name_dn": "Greenberg Agency",
"cst_eml_address_dn": "zztomG@mail.comzz",
"adr_line1": "4 Valley Farms St.",
"adr_city_state_code": "Muskego, WI 53150",
"cst_no_email_flag": "0"
},
{
"ind_last_name": "Hernandez",
"ind_first_name": "Eva",
"ind_mid_name": null,
"cst_org_name_dn": "Cisco LOCAL Organization",
"cst_eml_address_dn": null,
"adr_line1": "7706 E. Virginia Drive",
"adr_city_state_code": "Madisonville, KY 42431",
"cst_no_email_flag": "0"
},
{
"ind_last_name": "Jennings",
"ind_first_name": "Jim",
"ind_mid_name": null,
"cst_org_name_dn": null,
"cst_eml_address_dn": null,
"adr_line1": "10324 POE DR",
"adr_city_state_code": "MANASSAS, VA 20110",
"cst_no_email_flag": "0"
},
{
"ind_last_name": "joshi",
"ind_first_name": "Ravi",
"ind_mid_name": null,
"cst_org_name_dn": null,
"cst_eml_address_dn": null,
"adr_line1": "Ap #310-1678 Ut Av",
"adr_city_state_code": "Santa Barbara, MA 88317",
"cst_no_email_flag": "0"
},
{
"ind_last_name": "Lee",
"ind_first_name": "Bruce",
"ind_mid_name": null,
"cst_org_name_dn": "Lee Enterprises",
"cst_eml_address_dn": "bruce.lee@mailinator.com",
"adr_line1": "999 9th St NW",
"adr_city_state_code": "Washington, DC 20005",
"cst_no_email_flag": "0"
},
{
"ind_last_name": "Lynch",
"ind_first_name": "Lee",
"ind_mid_name": null,
"cst_org_name_dn": "INTACCT LOCAL Organization",
"cst_eml_address_dn": null,
"adr_line1": "859 Cottage St.",
"adr_city_state_code": "Ephrata, PA 17522",
"cst_no_email_flag": "0"
},
{
"ind_last_name": "Moltchanova",
"ind_first_name": "Nataliia",
"ind_mid_name": null,
"cst_org_name_dn": "ABC Company",
"cst_eml_address_dn": "nmoltchanova@gmail.com",
"adr_line1": "220 Seneca St",
"adr_city_state_code": "Lewiston, NY 14092",
"cst_no_email_flag": "0"
},
{
"ind_last_name": "Mouse",
"ind_first_name": "Mickey",
"ind_mid_name": null,
"cst_org_name_dn": null,
"cst_eml_address_dn": "zzMMouse@test.comzz",
"adr_line1": "Walt Disney World Resort",
"adr_city_state_code": "Orlando, FL 32830",
"cst_no_email_flag": "0"
},
{
"ind_last_name": "Murphy",
"ind_first_name": "Andrea",
"ind_mid_name": null,
"cst_org_name_dn": "DELL LOCAL Organization",
"cst_eml_address_dn": "amurphy@mailinator.com",
"adr_line1": "8157 South Grand St.",
"adr_city_state_code": "Clemmons, NC 27012",
"cst_no_email_flag": "0"
},
{
"ind_last_name": "nbnb",
"ind_first_name": "pooja",
"ind_mid_name": null,
"cst_org_name_dn": null,
"cst_eml_address_dn": null,
"adr_line1": "4017 Grant Street1",
"adr_city_state_code": "TX, FL 75501",
"cst_no_email_flag": "0"
},
{
"ind_last_name": "Newman",
"ind_first_name": "Amanda",
"ind_mid_name": null,
"cst_org_name_dn": "Audi Chantilly",
"cst_eml_address_dn": null,
"adr_line1": "fht 6 evr45",
"adr_city_state_code": "ynubtheyt, VA 50892",
"cst_no_email_flag": "0"
},
{
"ind_last_name": "Newman",
"ind_first_name": "Eric",
"ind_mid_name": null,
"cst_org_name_dn": null,
"cst_eml_address_dn": "zzzericN@mail.comzzz",
"adr_line1": "2131 Homey Ln",
"adr_city_state_code": "Vienna, VA 22182-1234",
"cst_no_email_flag": "0"
},
{
"ind_last_name": "Novak",
"ind_first_name": "Amy",
"ind_mid_name": null,
"cst_org_name_dn": "Acme Systems48fk9P",
"cst_eml_address_dn": null,
"adr_line1": "2133 Homey Ln",
"adr_city_state_code": "Bethesda, MD 20817",
"cst_no_email_flag": "0"
},
{
"ind_last_name": "Ortega",
"ind_first_name": "Eric",
"ind_mid_name": null,
"cst_org_name_dn": "DoubleTree by Hilton Hotel Orlando at SeaWorld",
"cst_eml_address_dn": null,
"adr_line1": "vtr rt56756",
"adr_city_state_code": "ertwetw, VA 42766",
"cst_no_email_flag": "0"
},
{
"ind_last_name": "Ourisman",
"ind_first_name": "Don",
"ind_mid_name": null,
"cst_org_name_dn": null,
"cst_eml_address_dn": null,
"adr_line1": "4800 Bethesda Ave",
"adr_city_state_code": "Bethesda, MD 20814",
"cst_no_email_flag": "0"
},
{
"ind_last_name": "Owens",
"ind_first_name": "Beatrice",
"ind_mid_name": null,
"cst_org_name_dn": "MCurr LOCAL Organization",
"cst_eml_address_dn": null,
"adr_line1": "77 Wrangler Street",
"adr_city_state_code": "Neptune, NJ 77531",
"cst_no_email_flag": "0"
},
{
"ind_last_name": "Perkins",
"ind_first_name": "Scott",
"ind_mid_name": null,
"cst_org_name_dn": null,
"cst_eml_address_dn": null,
"adr_line1": "P.O. Box 399 4275 Amet Street",
"adr_city_state_code": "West Allis, NC 36734",
"cst_no_email_flag": "0"
},
{
"ind_last_name": "Pratt",
"ind_first_name": "Sebastian",
"ind_mid_name": null,
"cst_org_name_dn": "Bell LOCAL Organization",
"cst_eml_address_dn": null,
"adr_line1": "123, Eastern highway",
"adr_city_state_code": "Hawaii, HI 78954",
"cst_no_email_flag": "1"
},
{
"ind_last_name": "Pravin",
"ind_first_name": "ClassicUI",
"ind_mid_name": null,
"cst_org_name_dn": "Akshay Org",
"cst_eml_address_dn": null,
"adr_line1": "888 1st Ave",
"adr_city_state_code": "Baker Lake, NU X0C 0A0",
"cst_no_email_flag": "0"
},
{
"ind_last_name": "product",
"ind_first_name": "pooja",
"ind_mid_name": null,
"cst_org_name_dn": "Test1 Org1",
"cst_eml_address_dn": "pooja.rakate@co.in",
"adr_line1": "Calista Wise 7292 Dictum Av.",
"adr_city_state_code": "San Antonio, MI 47096",
"cst_no_email_flag": "0"
},
{
"ind_last_name": "Prospect",
"ind_first_name": "Eric",
"ind_mid_name": null,
"cst_org_name_dn": null,
"cst_eml_address_dn": "zzericP@mailinator.comzz",
"adr_line1": "3124 Homey Ln",
"adr_city_state_code": "Vienna, VA 14092",
"cst_no_email_flag": "0"
},
{
"ind_last_name": "Prospectorus",
"ind_first_name": "Adam",
"ind_mid_name": "Jacob",
"cst_org_name_dn": "Prospect Inc",
"cst_eml_address_dn": "zzadamp@mailinator.comzz",
"adr_line1": "4309 S Morgan St",
"adr_city_state_code": "Chicago, IL 14092",
"cst_no_email_flag": "0"
},
{
"ind_last_name": "rakteeeee",
"ind_first_name": "pooja",
"ind_mid_name": null,
"cst_org_name_dn": "pooja org28",
"cst_eml_address_dn": null,
"adr_line1": "2071 Dawson Drive",
"adr_city_state_code": "Little Rock, AR 72212",
"cst_no_email_flag": "0"
},
{
"ind_last_name": "rakteeeeeee",
"ind_first_name": "pooja",
"ind_mid_name": null,
"cst_org_name_dn": "pooja org28",
"cst_eml_address_dn": null,
"adr_line1": "xyz",
"adr_city_state_code": "ny, NY 10003",
"cst_no_email_flag": "0"
},
{
"ind_last_name": "Richardson",
"ind_first_name": "Bruce",
"ind_mid_name": null,
"cst_org_name_dn": "Bell Company",
"cst_eml_address_dn": "hgg@ygk.com",
"adr_line1": "31 Greenview St.",
"adr_city_state_code": "Merrick, NJ 11566",
"cst_no_email_flag": "0"
},
{
"ind_last_name": "Ronaldo",
"ind_first_name": "Cristiano",
"ind_mid_name": null,
"cst_org_name_dn": "ABC Company",
"cst_eml_address_dn": "nikhil.baad@communitybrands.com",
"adr_line1": "Lakshire drive st109",
"adr_city_state_code": "Dublin, OH 20101",
"cst_no_email_flag": "0"
},
{
"ind_last_name": "Scattorade",
"ind_first_name": "Sara",
"ind_mid_name": null,
"cst_org_name_dn": null,
"cst_eml_address_dn": null,
"adr_line1": "8500 River Rd",
"adr_city_state_code": "Bethesda, MD 20817",
"cst_no_email_flag": "0"
},
{
"ind_last_name": "Scattorade",
"ind_first_name": "Violet",
"ind_mid_name": null,
"cst_org_name_dn": "ABC Warehouse",
"cst_eml_address_dn": "zzviolet@mail.comzz",
"adr_line1": "222 Seneca Street",
"adr_city_state_code": "Lewiston, NY 14092",
"cst_no_email_flag": "0"
},
{
"ind_last_name": "Scottorade",
"ind_first_name": "Tina",
"ind_mid_name": null,
"cst_org_name_dn": "Wyndham Garden",
"cst_eml_address_dn": null,
"adr_line1": "7002 Arundel Mills Cir",
"adr_city_state_code": "Hanover, MD 21706",
"cst_no_email_flag": "0"
},
{
"ind_last_name": "Singleton",
"ind_first_name": "Brittany",
"ind_mid_name": null,
"cst_org_name_dn": "MCurr Warehouse",
"cst_eml_address_dn": null,
"adr_line1": "969 East Whitemarsh Street",
"adr_city_state_code": "Amarillo, TX 79106",
"cst_no_email_flag": "0"
},
{
"ind_last_name": "Smith",
"ind_first_name": "Amanda",
"ind_mid_name": null,
"cst_org_name_dn": null,
"cst_eml_address_dn": null,
"adr_line1": "2313 Homey Ln",
"adr_city_state_code": "Vienna, VA 22102",
"cst_no_email_flag": "0"
},
{
"ind_last_name": "Smith",
"ind_first_name": "Wanda",
"ind_mid_name": null,
"cst_org_name_dn": null,
"cst_eml_address_dn": null,
"adr_line1": "999 8th St NW",
"adr_city_state_code": "Washinghton, DC 20005",
"cst_no_email_flag": "0"
},
{
"ind_last_name": "Snowman",
"ind_first_name": "Mandy",
"ind_mid_name": null,
"cst_org_name_dn": null,
"cst_eml_address_dn": null,
"adr_line1": "8500 River Rd",
"adr_city_state_code": "Bethesda, MD 20815",
"cst_no_email_flag": "0"
},
{
"ind_last_name": "Stark",
"ind_first_name": "Tony",
"ind_mid_name": null,
"cst_org_name_dn": "Stark Industries",
"cst_eml_address_dn": "zztony@mail.comzz",
"adr_line1": "230 WDC",
"adr_city_state_code": "Johns, FL 12345",
"cst_no_email_flag": "0"
},
{
"ind_last_name": "Stark2",
"ind_first_name": "Tonyyyy",
"ind_mid_name": null,
"cst_org_name_dn": "Marvel Organization",
"cst_eml_address_dn": "Tstark2@yopmail.com",
"adr_line1": "10800 Pecan Park Blvd.,",
"adr_city_state_code": "Austin, TX 78750",
"cst_no_email_flag": "0"
},
{
"ind_last_name": "Szarko",
"ind_first_name": "Joanna",
"ind_mid_name": "1630435362",
"cst_org_name_dn": "Community Brands - McLean",
"cst_eml_address_dn": "zzjoanna@communitybrands.comzz",
"adr_line1": "7901 Jones Branch Dr",
"adr_city_state_code": "Mclean, VA 22102-1234",
"cst_no_email_flag": "0"
},
{
"ind_last_name": "teke",
"ind_first_name": "manas",
"ind_mid_name": null,
"cst_org_name_dn": null,
"cst_eml_address_dn": "manas.teke@gmail.com",
"adr_line1": "P.O. Box 399 4275 Amet Street",
"adr_city_state_code": "West Allis, NC 36734",
"cst_no_email_flag": "0"
},
{
"ind_last_name": "test1",
"ind_first_name": "test2",
"ind_mid_name": null,
"cst_org_name_dn": null,
"cst_eml_address_dn": null,
"adr_line1": "testmailing",
"adr_city_state_code": "Mail, AZ 12354",
"cst_no_email_flag": "0"
},
{
"ind_last_name": "Test11",
"ind_first_name": "Deepti",
"ind_mid_name": null,
"cst_org_name_dn": null,
"cst_eml_address_dn": null,
"adr_line1": "7045 Bedrock RD # Alexandria",
"adr_city_state_code": "Alexandria, VA 22306",
"cst_no_email_flag": "0"
},
{
"ind_last_name": "Tuesday",
"ind_first_name": "Thomas",
"ind_mid_name": null,
"cst_org_name_dn": null,
"cst_eml_address_dn": null,
"adr_line1": "7 Leesburg Pk",
"adr_city_state_code": "Leesburg, VA 22169",
"cst_no_email_flag": "0"
},
{
"ind_last_name": "Wayde",
"ind_first_name": "John",
"ind_mid_name": null,
"cst_org_name_dn": null,
"cst_eml_address_dn": null,
"adr_line1": "8500 River Rd",
"adr_city_state_code": "Bethesda, MD 20817",
"cst_no_email_flag": "0"
},
{
"ind_last_name": "Welch",
"ind_first_name": "Nat4e",
"ind_mid_name": null,
"cst_org_name_dn": "ABC OrgWeb",
"cst_eml_address_dn": "Nat4e@abila.com",
"adr_line1": "220 Seneca St",
"adr_city_state_code": "Lewiston, NY 14092-1544",
"cst_no_email_flag": "0"
},
{
"ind_last_name": "Williams",
"ind_first_name": "Juan",
"ind_mid_name": null,
"cst_org_name_dn": "William David",
"cst_eml_address_dn": null,
"adr_line1": "86 Bear Hill St.",
"adr_city_state_code": "Ronkonkoma, NY 11779",
"cst_no_email_flag": "0"
},
{
"ind_last_name": "Wyane",
"ind_first_name": "Bruce",
"ind_mid_name": null,
"cst_org_name_dn": "Tower Corporation",
"cst_eml_address_dn": null,
"adr_line1": "909 Aviation Pkwy",
"adr_city_state_code": "New York, NY 54260",
"cst_no_email_flag": "0"
}
]
}
}
GetDynamicQueryDefinition Web Method
In order to understand the definition of a specific query, including its ask-at-runtime parameters, see the GetDynamicQueryDefinition web method. This web method is a companion "documentation" web method to GetDynamicQuery.
Pagination
GetDynamicQuery paginates the list results of the query. The currentPage parameter determines which page of results is returned. The number of records per page is determined by the system option DataGridRowLimit. The Results node also indicates how many total pages are available and the total count of records that were returned by the query overall.
If the currentPage parameter is not passed, pagination does not occur.
See Also
- Query - general understanding of how a user sets up a Query in the NetForum iWeb application
- xWeb:GetQuery - a more free-form web method.
- xWeb:GetDynamicQuery
- xWeb:GetQueryDefinition - the companion "documentation" web method to GetDynamicQuery.
- xWeb:ExecuteMethod - an alternate web method to get data from netFORUM.