{"uid":"cap_5w10q1dveP1VQ5P5Qrg69","slug":"payroll-input-imports-declared-column-projection-92832960","name":"Payroll Input Imports — Declared Column Projection","description":"Payroll input imports — Declared column projection: Declared column projection for Payroll input imports. Validate a declared CSV table contract, up to 1000 rows. Quoted cells supported; no external enrichment. Specialised preset in a shared 50-profile, 20-operation engine. 0.01 USDC includes one CSV declared column projection report.","url":"https://market.datapackvibe.com/x402/assistant-bx-csv-payroll-projection?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"csv":{"type":"string","default":"pay_id,period_ends_on,department_id,gross_pay,deductions\nrecord-a,2026-01-01,group-a,10,2\nrecord-b,2026-01-02,group-b,20,3","maxLength":100000,"minLength":1},"maximum":{"type":"number","default":1000000000000,"maximum":1000000000000,"minimum":-1000000000000},"minimum":{"type":"number","default":-1000000000000,"maximum":1000000000000,"minimum":-1000000000000},"delimiter":{"enum":[",",";","\t"],"type":"string","default":","},"max_cell_length":{"type":"integer","default":1000,"maximum":5000,"minimum":1},"allowed_categories":{"type":"array","items":{"type":"string","default":"","maxLength":100,"minLength":1},"default":["group-a","group-b"],"maxItems":100,"minItems":0}}},"responseSchema":null,"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.01","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.01/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.01","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.01","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_iBpjOEGpoa2roZ2A8azM-","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.01","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Validates a CSV payroll import file against a declared column schema contract, checking up to 1000 rows for structural and value compliance.","exampleAgentPrompt":"Can you validate this payroll CSV against the declared column contract — it uses comma delimiters, departments should be group-a or group-b, gross pay must be between 0 and 1000000, and I want to check up to 1000 rows: 'pay_id,period_ends_on,department_id,gross_pay,deductions\\nrecord-a,2026-01-01,group-a,5000,400'?","exampleUseCases":[{"title":"Pre-upload payroll file check","prompt":"Before I send this payroll CSV to our processor, can you validate it against the expected columns — pay_id, period_ends_on, department_id, gross_pay, deductions — using comma as delimiter, only allowing departments group-a and group-b, and values between 0 and 999999?"},{"title":"Catching bad department codes in payroll","prompt":"I've got a payroll import file and I need to make sure all department_id values are only 'group-a', 'group-b', or 'group-c' — can you run the declared column projection on it and flag any rows that violate those categories?"},{"title":"Payroll data integrity before month-end close","prompt":"It's month-end and I need to validate our payroll CSV before closing — semicolon-delimited file, gross_pay should be between 500 and 50000, deductions can't exceed 10000, and all cells under 200 characters. Can you run the column projection check?"}],"resultDescription":"Returns a declared column projection report for the payroll CSV, indicating whether the submitted data conforms to the declared schema contract — including per-column validation results, row-level issues, category violations, numeric range breaches, and cell-length failures across up to 1000 rows.","failureModes":["CSV exceeds 1000 rows — only first 1000 may be processed","Malformed CSV where quotes are unclosed — parse error returned","Numeric values outside specified minimum/maximum bounds flagged as violations","Cell content exceeding max_cell_length threshold reported per row","Delimiter mismatch causes single-column parse producing no valid structure","Empty CSV input (minLength:1 not met) — request rejected","Category values not in allowed_categories list flagged as invalid"],"whenToPreferThis":"Choose this endpoint when you need to validate a payroll-specific CSV file against a declared column contract before importing or processing it, especially when you need to enforce allowed department categories, numeric bounds on pay fields, and cell-length constraints without sending data to external enrichment services. It is purpose-built for payroll import schemas (pay_id, period_ends_on, department_id, gross_pay, deductions) rather than generic CSV validation.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-16T00:53:25.444Z","isFirstParty":false,"canonicalSlug":"payroll-input-imports-declared-column-projection-92832960"}