Examples of XML/JSON API

Owned by Rashmi Likhite
Last updated: Jun 09, 2014

All the URLs in the following examples must be prefixed by http://<celoxis-server-name>:<port>/psa/
 

  1. Find the list of all projects that are in progress

    api.do?function=query&table=db_project&status_id=1&data-format=json&token=a1dc42fb-d420-10feb-aaks9-89f5c0e8sk3c&data-format=xml

  2. Fetch details of task with id 100

    api.do?function=query&table=db_task&id=100&token=a1dc42fb-d420-10feb-aaks9-89f5c0e8sk3c&data-format=json

    Not specifying the data-format, defaults the result to XML format.
     

  3. Fetch tasks assigned to user with id 200

    api.do?function=query&table=db_task&join-with=db_assignment.task_id&db_assignment.user_id=200&data-format=json&token=a1dc42fb-d420-10feb-aaks9-89f5c0e8sk3c

  4. Execute a query using SQL (This example can only be used by On-Premise customers) 

    api.do?function=query&table=generic&sql=select+id+from+db_project+where+fixed_price+>+100000