1.2. Examples
Prev Chapter 1. API Guide Overview Next

1.2. Examples

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

Find the list of all projects that are in progress
api.do?function=query&table=db_project&status_id=1
Fetch details of task with id 100
api.do?function=query&table=db_task&id=100
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
Execute a query using SQL
api.do?function=query&table=generic&sql=select+id+from+db_project+where+fixed_price+>+100000

You can find a detailed list of functions supported in the function reference chapter.

Prev Up Next
1.1. Introduction Home 1.3. Representation Formats