Post

2 followers Follow
0
Avatar

Celigo to Clarizen

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. 

 

Jackie Beaupre Answered

Please sign in to leave a comment.

8 comments

0
Avatar

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

Jackie Beaupre 0 votes
Comment actions Permalink
0
Avatar

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

 

Jackie Beaupre 0 votes
Comment actions Permalink
0
Avatar

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

Roland Pumputis 0 votes
Comment actions Permalink
0
Avatar

Thank you, making progress. 

Where can I find a list of fields for Projects to build my query. 

Appreciate the help

Jackie Beaupre 0 votes
Comment actions Permalink
0
Avatar

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.

Jackie Beaupre 0 votes
Comment actions Permalink