List pending timesheets
If you wish to access multiple tspending records you would normally use the tspendingslist model
For more details about using models see Using data models
For tspending two models are available:
- tspendingslist
- tspendingdetails
Retrieve a list of pending timesheets
| Parameter | Description | Examples |
|---|---|---|
| API | The API area | tspending.json |
| Action | Defines the API | no action required |
| General | Parameters described in overview | user=user\&password=user\&version=3.3 |
| Resource | Filter by resource | resource=1/jon |
| From date | Date filter | datefrom=2015-07-01 |
| To date | Date filter | dateto=2015-07-01 |
| Modelstructure | Name of model required | Modelstructure=tspendingslist |
| Filters | Filter by a key field |
Multi-value filters
It's possible to include multiple values for companies & Resources (see examples below)
Filtering the list
Key field filters
Example request:
Request to list pending timesheets
Statuses
P – Posted … (if in process of being posted)
A - Approved
Q - Queried
R - rejected
H - held
W – web/pending/default status (not included in this API return data)
Example using a date and resource filter
http://<SERVER>/jsonAPI/tspending.json?user=user&password=user&version=3.3&company=1&resource=1/jon&datefrom=2015-07-01&dateto=2015-07-01&modelstructure=tspendingslist
Example using a multiple resource filter
http://<SERVER>/jsonAPI/tspending.json?user=user&password=user&version=3.3&company=1&resource=["1/JON","1/KAT","1/PR"]&modelstructure=tspendingslist
Example using a multiple company filter
http:///jsonAPI/tspending.json?user=user&password=user&version=3.3&company=[1,5,8]&modelstructure=tspendingslist
Example response:
{
"responsecode": 1,
"responsestatus": "OK",
"errorcode": 0,
"errormessage": "",
"totalrows": 145,
"totalpages": 1,
"responsemessage": "",
"pagerows": 0,
"pagenumber": 1,
"success": true,
"data": [
{
"tspUuid": "71E8D950EC3F48DCBAC30C03D768B8BD",
"tspTimeStampModified": 1490360812,
"tspRecordVersionNumber": 11,
"tspEntryNo": 686,
"tspJobAndPhase": "1/00000772.001",
"tspStageCode": "",
"tspStageDescription": "",
"tspTaskDescription": "",
"tspChargeCode": "1/MAC",
"tspChargeCodeDescription": "MAC Work",
"tspResourceCode": "1/USER",
"tspResourceName": "User",
"tspMaterialCode": "1/A2CC",
"tspMatQuantity": 1,
"tspHoursNormal": 0,
"tspHoursOtime1": 0,
"tspHoursOtime2": 0,
"tspTimeDate": "2011-11-01"
},etc ...