Clarity

  • 1.  WebService/SOAP request based in a query including a URL param

    Posted Feb 19, 2016 06:24 AM

    I would like to be able to execute a query using a SOAP request, but its default WSDL definition filter doesn't seem enough to see results because the Query has a WHERE clause like the following:

     

    WHERE    l.lookup_code = @where:param:xml:string:/data/license_type/@value@

     

    How can I send by SOAP the value for this WHERE clause?

    How can i add this  parameter to SOAP filter section?

     

    Previous example is based in a default Clarity Query (userlistbylicensetype) and .../wsdl/Query/userlistbylicensetype

     

    Any idea?

    Thanks

     



  • 2.  Re: SOAP request for a query with a url param
    Best Answer

    Posted Feb 19, 2016 06:54 AM

    Web-service query calls can (I would assume) only cope with the @WHERE:PARAM:USER_DEF:..... parameters

     

    So perhaps recode (or take a copy of) the NSQL something like;

     

    WHERE    l.lookup_code = @NVL@ ( @where:param:xml:string:/data/license_type/@value@ , @WHERE:PARAM:USER_DEF:STRING:license_type@ )

     

    and call your query over SOAP with a <filter> section;

     

    <Query xmlns="http://www.niku.com/xog/Query">

    <Code>my_query_code</Code>

    <Filter>

    <param_license_type>my_value</param_license_type>

    </Filter>

    </Query>