{"uid":"cap_r1maqo6Rcr0ebT-lL7PIY","slug":"hermes-clean-normalize-json-csv-data-quality-942e2810","name":"Hermes Clean & Normalize – JSON/CSV Data Quality","description":"Agent utilities for company research, package maintenance intelligence, dependency vulnerability checks, counterparty availability, SEC company snapshots, OFAC sanctions screening, and deterministic JSON/CSV data-quality work. Company domain intelligence includes a free preview before the paid enrichment call.","url":"https://hermes-counterparty-api.onrender.com/v1/clean-normalize","method":"POST","headers":{},"bodySchema":{"type":"object","$schema":"https://json-schema.org/draft/2020-12/schema","required":["input"],"properties":{"input":{"type":"object","required":["type","method","bodyType","body"],"properties":{"body":{"oneOf":[{"type":"object","required":["format","records"],"properties":{"format":{"type":"string","const":"json"},"options":{"type":"object","properties":{"deduplicate":{"type":"boolean"},"trim_strings":{"type":"boolean"},"blank_to_null":{"type":"boolean"}}},"records":{"type":"array","items":{"type":"object"}}}},{"type":"object","required":["format","data"],"properties":{"data":{"type":"string"},"format":{"type":"string","const":"csv"},"options":{"type":"object","properties":{"deduplicate":{"type":"boolean"},"trim_strings":{"type":"boolean"},"blank_to_null":{"type":"boolean"}}}}}]},"type":{"type":"string","const":"http"},"method":{"enum":["POST"],"type":"string"},"bodyType":{"enum":["json","form-data","text"],"type":"string"}},"additionalProperties":false},"output":{"type":"object","required":["type"],"properties":{"type":{"type":"string"},"example":{"type":"object"}}}}},"responseSchema":{"type":"json","example":{"records":[{"id":1,"name":"Alice"}],"schema_version":"1.0","transformations":{"blanks_to_null":0,"trimmed_strings":1,"duplicates_removed":1},"schema_fingerprint":"sha256:example","cleaned_record_count":1,"original_record_count":2,"removed_duplicate_rows":1}},"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.02","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.02/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.02","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.02","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_1Y3-cFYqotRpsy5FYIpvQ","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.02","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Cleans and normalizes JSON or CSV records by trimming strings, converting blanks to nulls, and deduplicating rows, returning a cleaned dataset with transformation statistics.","exampleAgentPrompt":"Take these JSON records and clean them up — trim any whitespace from strings, convert blank fields to null, and remove duplicates: [{\"id\":1,\"name\":\" Alice \"},{\"id\":1,\"name\":\" Alice \"},{\"id\":2,\"name\":\"\"}].","exampleUseCases":[{"title":"Deduplicate scraped product catalog","prompt":"I scraped a product catalog and there are a bunch of duplicate rows — can you send this JSON records array through the Hermes cleaner with deduplication on and give me back the cleaned list plus a count of how many dupes were removed?"},{"title":"Normalize CSV export before database load","prompt":"I have a CSV export from our CRM with lots of trailing spaces in the name column and empty strings instead of nulls — please clean it with trim_strings and blank_to_null enabled so it's ready to load into the database."},{"title":"Audit data transformations on a JSON dataset","prompt":"Run this batch of JSON records through the data quality cleaner with all three options turned on — deduplication, string trimming, and blank-to-null — and show me the transformation summary so I know exactly what changed."}],"resultDescription":"Returns a JSON object containing the cleaned records array, the cleaned and original record counts, number of duplicate rows removed, counts of specific transformations applied (blanks converted to null, strings trimmed, duplicates removed), a schema fingerprint (SHA-256 hash), and the schema version.","failureModes":["Missing required 'input' field returns a validation error","Supplying both JSON and CSV body formats in a single request may cause oneOf schema conflict","Invalid CSV string (malformed) may result in parse error","Network or server unavailability on Render free-tier host may cause timeouts","Insufficient USDC balance or failed x402 payment returns 402 Payment Required"],"whenToPreferThis":"Choose this endpoint when you need deterministic, auditable data-quality transformations (deduplication, string trimming, blank-to-null conversion) on JSON record arrays or raw CSV strings and want a transformation summary report alongside cleaned data. Prefer it over generic ETL tools when you need micropayment-per-call pricing with no subscription, or when working in an agent pipeline that already handles x402 payments.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-09-15T06:42:59.657Z","isFirstParty":false}