{"uid":"cap_stkiC4WsYNFm1AdVbeuxm","slug":"crustdata-job-listings-table-via-orthogonal-02effa00","name":"Crustdata Job Listings Table via Orthogonal","description":"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.","url":"https://x402.orthogonal.com/crustdata/data_lab/job_listings/Table/?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"count":{"type":"integer","description":"Number of rows to return (min: 1). Default: 100."},"sorts":{"type":"array","description":"Sorting criteria array. Usually empty []."},"groups":{"type":"array","description":"Grouping. Usually empty []."},"offset":{"type":"integer","description":"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."},"dataset":{"type":"object","description":"Must be {\"name\": \"job_listings\", \"id\": \"joblisting\"}."},"filters":{"type":"object","description":"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\", \">\", \"<\", \">=\", \"<=\", \"=\"."},"tickers":{"type":"array","description":"Ticker symbols. Usually empty []."},"functions":{"type":"array","description":"Functions. Usually empty []."},"aggregations":{"type":"array","description":"Aggregations. Usually empty []."}}},"responseSchema":null,"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.313","displayCostAsset":"USDC","priceDynamic":false,"priceHint":null,"priceStatus":"priced","priceSource":"probe","requiresHandshake":false,"reviewCount":0,"rating":{"score":"0.00","successRate":"0.00","reviews":0,"stars":null,"state":"unrated"},"availabilityStatus":"unknown","priceObserved":null,"sessionDeposit":null,"pricing":{"kind":"static","summary":"$0.313/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.313","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.313","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_9Pgh_JkafTSb-RQlG7BqI","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.313","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Query and filter Crustdata's job listings database by company, date, location, title, and remote status, returning paginated tabular results.","exampleAgentPrompt":"Pull the 50 most recent job listings from Crustdata for company IDs 7576 and 680992 that were updated after March 1, 2024, filtering for remote positions only.","exampleUseCases":[{"title":"Track competitor hiring activity","prompt":"Get me all job listings posted after January 1, 2024 for company IDs 7576 and 680992 from Crustdata — I want to see what roles they've been hiring for recently."},{"title":"Find remote engineering roles at target startups","prompt":"Search Crustdata's job listings database for remote software engineer positions at company ID 7576, updated in the last 90 days — return the first 100 results."},{"title":"Monitor a company's open headcount","prompt":"How many job postings does company ID 680992 currently have on Crustdata? Pull all listings with no date filter and give me the full list so I can count by department."}],"resultDescription":"A fields-and-rows structure where 'fields' is an array of column descriptors (name, type) and 'rows' is an array of job listing records matching the filters. Each row contains values for columns such as job title, location, remote status, date updated, and company ID. Also includes a billing requestId in the Orthogonal response envelope for pagination cost-tracking.","failureModes":["Invalid or missing company_id values cause empty results — use Company Identification endpoint first to resolve IDs","Malformed filter conditions (wrong type or column name) return an error or no rows","Offset beyond total result count returns empty rows","Changing filters while passing parentRequestId creates a mismatch and may result in billing errors or rejected requests","Missing required dataset object (name/id) causes request failure","Rate limits or payment failures result in HTTP 402 or 429 errors"],"whenToPreferThis":"Choose this endpoint when you need structured, filterable job listing data from Crustdata's proprietary database — especially when filtering by specific company IDs, date ranges, locations, or remote status. It is preferable to general web job search when you need consistent tabular output, programmatic filtering, or are building talent intelligence pipelines. Use the LinkedIn job search sibling endpoint instead if you need broader web-scraped postings without company ID resolution.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-20T00:50:48.313Z","isFirstParty":false,"canonicalSlug":"crustdata-job-listings-table-via-orthogonal-02effa00"}