Hi,
We are working on using Celigo to connect to Clarizen sandbox and pull projects back.
When I use this endpoint with our credentials, Celigo says connection successful.
https://app.clarizentb.com/Clarizen/
When I then try to get Projects to test the connection, I use this:
https://app.clarizentb.com/Clarizen/Pages/Service/data/objects/project
Get Error back 404 - File or directory not found.
So, is our initial endpoint correct?
Is our endpoint for projects correct?
Do we need to install something for Clarizen into Celigo?
Any help will be appreciated.
Hi Jackie,
Please refer to this: https://api.clarizen.com/v2.0/services/
The endpoint should be this: https://api.clarizen.com/V2.0/services/data/objects/project
I hope this helps.
Roland
Please sign in to leave a comment.
Hi,
Thank you, appreciate the prompt response.
What we need is the sandbox access right now, I apologize for not specifying that.
Based on what you sent me I tried again with this
https://app.clarizentb.com/v2.0/services/data/objects/project
I get this error with that
Are you sure you want to save this connection? Test connection failed with the following error: <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"/> <title>404 - File or directory not found.</title> <style type="text/css"> <!-- body{margin:0;font-size:.7em;font-family:Verdana, Arial, Helvetica, sans-serif;background:#EEEEEE;} fieldset{padding:0 15px 10px 15px;} h1{font-size:2.4em;margin:0;color:#FFF;} h2{font-size:1.7em;margin:0;color:#CC0000;} h3{font-size:1.2em;margin:10px 0 0 0;color:#000000;} #header{width:96%;margin:0 0 0 0;padding:6px 2% 6px 2%;font-family:"trebuchet MS", Verdana, sans-serif;color:#FFF; background-color:#555555;} #content{margin:0 0 0 2%;position:relative;} .content-container{background:#FFF;width:96%;margin-top:8px;padding:10px;position:relative;} --> </style> </head> <body> <div id="header"><h1>Server Error</h1></div> <div id="content"> <div class="content-container"><fieldset> <h2>404 - File or directory not found.</h2> <h3>The resource you are looking for might have been removed, had its name changed, or is temporarily unavailable.</h3> </fieldset></div> </div> </body> </html> .
Thanks
Hi Jackie,
It should be https://api.clarizentb.com/V2.0/services/data/objects/project and not https://app.clarizentb.com/v2.0/services/data/objects/project
Best regards,
Roland
Thanks,.
So in postman I got connected and received a Session ID back using this:
https://api.clarizentb.com/v2.0/services/authentication/login (I still cannot get this to work from Celigo)
I took the session ID, plugged into Postman Get like this, and get error. See below. Can we get ALL projects back or do we need IDS?
but I get message saying ID is missing
Hi Jackie,
This endpoint (https://api.clarizentb.com/V2.0/services/data/objects/project) can only get one project's data based on the ID provided.
If you would like to get more than one project, this is how you can do it: GET https://api.clarizentb.com/V2.0/services/data/Query?q=SELECT Name,SYSID,etc (any other Project field API name)... FROM Project LIMIT 5000
This will get the first 5000 projects (maximum). To get next 5k, you can use OFFSET parameter: https://api.clarizentb.com/V2.0/services/data/Query?q=SELECT Name,SYSID,etc... FROM Project LIMIT 5000 OFFSET 5000
Best regards,
Roland
Thank you, making progress.
Where can I find a list of fields for Projects to build my query.
Appreciate the help
Hi Jackie,
In configuration:
In metadata explorer: https://oneus.clarizentb.com/metadata-explorer/Project
Or via API: https://api.clarizentb.com/V2.0/services/metadata/DescribeEntities
Best regards,
Roland
Awesome, thank you.
Now I just need Celigo to help us get setup in there.
I have it working through postman now, appreciate the help.
