get Expense Transaction list Import

get

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

Retrieves a list of records in the Data Import > Expense module. To pull all records with a new status simply pass the filter for loadStatus:N

Recent Requests

Time	Status	User Agent
Retrieving recent requests…

Loading…

Query Params

fieldValue5

string

Additional Field 5

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.

hdrTitle

string

Report Title

expCode

string

Expense Code - Max size 20 Characters

fieldValue4

string

Additional Field 4

lastName

string

Last Name

fieldValue2

string

Additional Field 2

level1Code

string

WBS Level1 Code - Max size 20 Characters

batchId

string

Batch Id allows import by the provided matching batch or if not provided a default batch number will be created.

page

number

Return Page Number

optCode

string

Operation Unit Code - Max size is 20 Characters

level2Code

string

WBS Level2 Code - Max size 20 Characters

effectiveFrom

string

Filters result based on travel date. YYYY-MM-DD

level4Code

string

WBS Level4 Code - Max size 20 Characters

currencyFrom

string

Charged Currency Code

level3Code

string

WBS Level3 Code - Max size 20 Characters

effectiveTo

string

Filters result based on travel date. YYYY-MM-DD

expType

string

Expense Type Id

fieldValue1

string

Additional Field 1

reportType

string

Report Type Id

emplyId

string

Employee ID

deptCode

string

Department Code

fieldValue3

string

Additional Field 3

loadStatus

string

Load status. N - New, P - Posted, W - Warning, I - Information, E - Error

payId

string

Payment Type Id

firstName

string

First Name

limit

number

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

number

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

Language

Credentials

Header

Loading…

Response

Click Try It! to start a request and see the response here! Or choose an example:

application/json

200successful operation