Job Listings
Get job listings from Crustdata's database. Filter by company, date, location, and more. Returns a fields-and-rows structure where fields describe column names/types and rows contain the data. Use Company Identification endpoint first to get company_id values for filtering. Pagination billing: call the first page normally and save billing.requestId from the Orthogonal /v1/run response. For later page, offset, or cursor calls on the same logical search, pass parentRequestId with unchanged non-pagination parameters. Valid continuation calls still get their own request IDs and quoted price, but are charged 0. Changing filters starts a new billable request.
Example code
// Using @orth/sdk - The simplest way to call APIs
// Install: npm install @orth/sdk
import Orthogonal from "@orth/sdk";
const orthogonal = new Orthogonal({
apiKey: process.env.ORTHOGONAL_API_KEY,
});
const output = await orthogonal.run({
api: "crustdata",
path: "/data_lab/job_listings/Table/",
body: {
"dataset": {},
"filters": {}
}
});
console.log(output);Body parameters
Must be {"name": "job_listings", "id": "joblisting"}.
Filter object: {"op": "and", "conditions": [...]}. Each condition: {"column": "...", "type": "...", "value": ...}. Key columns: company_id (type: "in", value: [7576, 680992]), date_updated (type: ">", value: "2024-01-01"), job_title_name, job_location, remote_status. Types: "in", "not in", ">", "<", ">=", "<=", "=".
Pagination offset. Default: 0. For later offset pages of the same logical search, keep non-pagination parameters unchanged and pass top-level parentRequestId from the first Orthogonal /v1/run response.
Number of rows to return (min: 1). Default: 100.
Sorting criteria array. Usually empty [].
Ticker symbols. Usually empty [].
Grouping. Usually empty [].
Aggregations. Usually empty [].
Functions. Usually empty [].
Response
Actual Orthogonal credits charged for this /v1/run call. Accepted continuation pages are charged 0.
Price this call would normally cost before continuation billing is applied.
Unique Orthogonal request ID for this page or poll call. Save the first call requestId and pass it as parentRequestId on later pages.
Parent Orthogonal request ID when this call is a continuation of an earlier search.
Root Orthogonal request ID for the full logical search.
True when this call was accepted as a continuation page or poll.
False for accepted continuation pages because they are not charged again.
Quoted price for this page or poll before continuation billing.
Actual credits charged for this page or poll. Accepted continuations return 0.
Total charged so far for the full logical search, including the first page and accepted continuations.