Add up placement fees
Read the fees your desk has recorded for hires, with a separate total for each currency.
Sam has accepted Alex’s offer and you’ve recorded the fee. You want to see what the desk has on its other hires, too. This report counts the applications currently at Hired that your workspace key can read, including hires on closed jobs. It adds the fee on each application, so an unpaid invoice or a placement that fell through can still have a recorded fee. Follow Sam’s placement
1. Read the hires
Ask for the application ID, currency and fee. Set first to 100 and leave after empty for the first call. If hasNextPage is true, repeat the call with endCursor as after. Read job applications
query ReadPlacementFees($first: Int!, $after: String) {
jobCandidates(filter: { stages: [HIRED] }, first: $first, after: $after) {
edges { node { id currency placementFee } }
pageInfo { hasNextPage endCursor }
}
}2. Add the fees in each currency
Add the GBP amounts together and do the same for USD or any other currency. Keep a count of hires with a missing fee. For example, three GBP hires with fees of £12,500, £0 and one blank give you £12,500 recorded and one fee missing. The zero is a recorded amount. Placement fee and currency fields
The Python example reads every page and adds the decimal amounts with Python’s decimal arithmetic. With your workspace key in KITH_ATS_API_KEY, download the script and run it against your member endpoint. Download the Python report
python3 placement-fees.py https://api.authin.ai/api/graphqlEach page reads the records visible at the time of that call. If someone moves an application or edits a fee during a long run, rerun the report after those changes settle.