Get Expense Report Search List

get

https://api.data-basics.net/apihub/apis/getExpenseSearchList

Expense Search Utility to retrieve expense reports based on filter query

Recent Requests

Time	Status	User Agent
Retrieving recent requests…

Loading…

Query Params

optCode

string

Operation Unit Code - Max size is 20 Characters

reportType

string

Report Type Id

hdrStatus

string

Current Status. The values are R - For Released, H - For Draft/On Hold, Z - Closed, J - Rejected, P - In Approval Process, O - for Opened, A - Approved

dateFrom

string

From Date - Format YYYY-MM-DD

fileAttachment

string

File Attached - Y - Yes and N - No file attached

level2Code

string

WBS Level2 Code - Max size 20 Characters

notPostedTo

string

Not Posted To - it will be based on the batch type. You would need to get the value from admin for which batch type is used. Usually it is DB

countryId

string

Country Id

currentAppLevel

string

Approval Queue Status, R - Ready, N - Not Ready, A - Approver

approver

string

Approver ID

expType

string

Expense Type Id

exception

string

Filter by the following exceptions: AWOA - IN Approval with no approvers and RWOA - Released without Approval

locationCode

string

Location Code - Max size 20 Characters

postedToDate

string

To Posted Date

vendorId

string

Vendor Id - Max size 20 Characters

myGroup

string

Filter based on My Group - D - My Department Approval, P - My Proxy , U - My team approval. No need to provide anything and it retrieve the data based on the filter.

batchId

string

Posted Batch Number

postedFromDate

string

From Posted Date

reportId

integer

Report Id

jobTitle

string

Employee Job Title

attributeValue

string

Additional Field Value

dateTo

string

To Date - Format YYYY-MM-DD

nFirst

string

First Name

certifyStatus

string

Certify Status - R - Require User Certification, X - No action needed, Y - User Certified The Report.

processStatus

string

Process Status - C - Fully paid, X - Not Processed (Default) , I - Partially Paid, P - Posted for Payment

deptCode

string

Department Code

prevStatus

string

Previous Status. The values are R - For Released, H - For Draft/On Hold, Z - Closed, J - Rejected, P - In Approval Process, A - Approved

modifiedDateTo

string

Last Modified Date To. Filters to the date provided and defaults time to 23:59 hours - format YYYY-MM-DD (Available Version 7.5 and up)

hasReimburse

string

Reimbursable to the owner of the report - Y - Reimbursable and N - Not reimbursable

attributeTag

string

Additional Fields ID - Such as Employee

level2Ftext

string

WBS Level2 Name

nLast

string

Last Name

postedTo

string

Posted To - it will be based on the batch type. You would need to get the value from admin for which batch type is used. Usually it is DB

validationStatus

string

Validation Status - X - No validation available, V - Passed with warnings, R Passed and I - Failed

level1Ftext

string

WBS Level1 Name

stateId

string

State Id - Max size 20 Characters

emplyType

string

Employee Type ID

placeId

string

Place Id - Max size 20 Characters

level1Code

string

WBS Level1 Code - Max size 20 Characters

modifiedDateFrom

string

Last Modified Date From. Filters from the date provided and defaults time to 00:00 hours - format YYYY-MM-DD (Available Version 7.5 and up)

emplyId

string

Employee ID

reportCurrency

string

Report Currency ID

limit

integer

Return number of records per page. Default page size is 20 rows. If you want to run 100 rows per page set it to 100. Max is 1000 per page.

start

integer

Start defines which record to begin from in the response. If the response has 20 records and you only want to return the last 10, then set the start equal to 9 to only return records 10 through 20.

Response

200successful operation