Integration Question

[Arunachalam Angusamy]

Hi Everyone, 

I am working on integration from Clarity to other sharepoint system. I am new to this integration area. Could you please give me an assistance ?

What is the webservice method that we can use to get the list of projects from clarity URL below ? 

https://cppm-test.ondemand.ca.com/niku/wsdl/Query/

[David Morton]

That ^ link should give you a list of the Queries that you have in your Clarity system - so if you have a query that gives you a list of your projects then you would see it there. If you don't have such a query, create one!

You could use the NSQL below to create one, it does not do much but it is a start

SELECT @SELECT:DIM:USER_DEF:IMPLIED:x:I.ID:ID@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:x:I.CODE:CODE@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:x:I.NAME:NAME@
FROM INV_INVESTMENTS I
WHERE 1=1
AND @WHERE:SECURITY:PROJECT:I.id@
AND @FILTER@

(the SECURITY line is there to ensure that the user that you execute that query via has access to the project in the system, otherwise it would show you everything - your use case may or may not want to do that)

[Arunachalam Angusamy]

Hi David, 

I have the query created and I am trying to get the xml file after providing the necessary information in SOAP UI

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:quer="http://www.niku.com/xog/Query">
<soapenv:Header/>
<soapenv:Body>
<quer:Login>
<quer:Username></quer:Username>
<!--Optional:-->
<quer:Password></quer:Password>
<!--Optional:-->
<quer:TenantID>clarity</quer:TenantID>
</quer:Login>
</soapenv:Body>
</soapenv:Envelope>

I passed the necessary information but I get this below error message

Any thour

[David Morton]

OK I never use an IDE or even Sharepoint to directly pull data so I really don't know the answer to your specific problem. (Incidentally that XML you posted looks just like a "log in" XML and nothing to do with a query call at all)

However what you are using here (in Clarity terms) is the "query API" and so I'd check the documentation ; eg HERE and any other discussions on these boards about "query API" for clues.

The confusing thing that you might not expect if you understand all that WSDL business is that (to me, from a position of relative ignorance about these things) what Clarity gives you (i.e. what is exposed on that .../niku/wsdl/query URL) is itself, not much use - but I do know that if you construct SOAP messages and use the relevant XML (as per the documentation) it all works fine.

(i.e. the .../niku/wsdl/query stuff does not really tell you how to consume the service, but the common "call a query" XML code works for any of the queries exposed on that URL)

[Nick Darlington]

Your endpoint address at the top of the window in the address bar of SoapUI should look like this:

https://cppmnnnn-test.ondemand.ca.com/niku/xog

Change the 'nnnn' to your own values, make sure it starts with https, and that you end with just /niku/xog as I have above.

[Joshua Leone]

Another option... we've created a connector that links Clarity to Microsoft Power Automate (Flow) to solve these SharePoint integration problem.
Information here and attached:
https://docs.microsoft.com/en-us/connectors/regolink/
https://www.youtube.com/watch?v=U_-DhcrIP54
https://www.youtube.com/watch?v=fil3ajZnin4
https://www.youtube.com/watch?v=IeAFEvDNtbc

Thanks,
Josh

Attachment(s)

RegoLink - Clarity Flow Connector_v2.pdf   729 KB 1 version