{"id":"csv-anti-join","version":"1.0.0","description":"Keep left CSV rows whose exact key tuples do not appear in the right document.","supported_operations":["csv anti join","keep unmatched left csv rows","csv rows absent from right keys"],"unsupported_operations":["inner join","left join","outer join","fuzzy keys","numeric keys","suffix collision renaming","read files","fetch urls"],"semantics":["keys names unique existing headers on both sides; equality uses exact string tuples with no trimming, case folding, or type coercion.","Output CSV uses left headers and left cells only, in original left data-row order.","Duplicate left keys are kept when unmatched; duplicate right keys only populate the set of right key tuples.","Empty documents without headers are rejected. Header-only right keeps every left data row. Header-only left yields header-only output.","rows_in is the number of left data rows; rows_out is the number of unmatched left data rows kept.","The first left header name may not begin with U+FEFF because it is ambiguous with a CSV byte-order mark."],"limits":{"max_input_bytes":256000,"max_data_rows":5000,"max_columns":256,"max_header_name_bytes":256,"max_keys":32,"max_output_bytes":256000},"pricing":{"status":"unpriced","charge_usd":null},"input_schema":{"type":"object","additionalProperties":false,"required":["left","right","keys"],"properties":{"left":{"type":"string","maxLength":256000},"right":{"type":"string","maxLength":256000},"keys":{"type":"array","minItems":1,"maxItems":32,"uniqueItems":true,"items":{"type":"string","minLength":1}}}},"output_schema":{"type":"object","additionalProperties":false,"required":["csv","rows_in","rows_out"],"properties":{"csv":{"type":"string","maxLength":256000},"rows_in":{"type":"integer"},"rows_out":{"type":"integer"}}},"examples":[{"input":{"left":"id,name\n1,Ada\n2,Lin\n3,Grace\n","right":"id,city\n2,London\n4,Paris\n","keys":["id"]},"output":{"csv":"id,name\n1,Ada\n3,Grace\n","rows_in":3,"rows_out":2}}],"execute_url":"/v1/tools/csv-anti-join/versions/1.0.0/execute"}