{"uid":"cap_1wiBZTQtWhvpQ0i6KgK8A","slug":"energybilltoolkit-co-uk-7a25f662","name":"M2M Trust Data Quality Audit","description":"M2M Trust deterministic analysis tool: Deterministic flat-JSON dataset audit for missingness, invalid values, duplicates, cardinality and numeric ranges.","url":"https://energybilltoolkit.co.uk/m2m-trust/api/tools/data-quality-audit","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"schema":{"type":"object","description":"Optional strict field rules for type/required/range/length/value validation.","additionalProperties":{"type":"object","required":["type"],"properties":{"max":{"type":"number"},"min":{"type":"number"},"type":{"enum":["number","integer","string","boolean"],"type":"string"},"required":{"type":"boolean"},"max_length":{"type":"integer","minimum":0},"min_length":{"type":"integer","minimum":0},"allowed_values":{"type":"array","items":{"type":["string","number","integer","boolean"]},"minItems":1}},"additionalProperties":false}},"context":{"type":"string","description":"Short domain context for interpretation."},"records":{"type":"array","items":{"type":"object","additionalProperties":{"type":["string","number","integer","boolean","null"]}},"maxItems":1000,"minItems":1,"description":"Flat JSON objects only. Nested objects, arrays, files/blobs, NaN and infinities are rejected."}}},"responseSchema":null,"example":{"request":{"input":{"body":{"schema":{"status":{"type":"string","required":true,"allowed_values":["paid","pending","overdue"]},"cost_gbp":{"max":500,"min":0,"type":"number","required":true},"usage_kwh":{"max":2000,"min":0,"type":"number","required":true},"customer_id":{"type":"string","required":true},"billing_period":{"type":"string","required":true,"max_length":7,"min_length":7}},"context":"Energy billing records for audit validation","records":[{"status":"paid","cost_gbp":125.3,"usage_kwh":450.5,"customer_id":"CUST001","billing_period":"2024-01"},{"status":"pending","cost_gbp":89.75,"usage_kwh":320,"customer_id":"CUST002","billing_period":"2024-01"},{"status":"paid","cost_gbp":162.5,"usage_kwh":580.25,"customer_id":"CUST003","billing_period":"2024-01"}]},"type":"http","method":"POST","bodyType":"json"}},"response":{"status":"Ready","verdict":"Dataset passed the bounded quality audit and is safe for the next deterministic analysis step.","metadata":{"context":"Energy billing records for audit validation","metrics":{"field_count":5,"record_count":3,"duplicate_rows":{"count":0,"truncated":false,"row_indexes":[]},"field_profiles":{"status":{"missing":0,"present":3,"required":true,"cardinality":2,"schema_type":"string","inferred_type":"string","non_null_count":3,"null_or_missing_share":0},"cost_gbp":{"missing":0,"present":3,"required":true,"cardinality":3,"schema_type":"number","inferred_type":"number","numeric_range":{"max":162.5,"min":89.75,"range":72.75},"non_null_count":3,"null_or_missing_share":0},"usage_kwh":{"missing":0,"present":3,"required":true,"cardinality":3,"schema_type":"number","inferred_type":"number","numeric_range":{"max":580.25,"min":320,"range":260.25},"non_null_count":3,"null_or_missing_share":0},"customer_id":{"missing":0,"present":3,"required":true,"cardinality":3,"schema_type":"string","inferred_type":"string","non_null_count":3,"null_or_missing_share":0},"billing_period":{"missing":0,"present":3,"required":true,"cardinality":1,"schema_type":"string","inferred_type":"string","non_null_count":3,"null_or_missing_share":0}},"invalid_values":{"total":0,"by_field":{},"examples":[],"required_missing_by_field":{}},"missing_values":{"total":0,"by_field":{"status":0,"cost_gbp":0,"usage_kwh":0,"customer_id":0,"billing_period":0}},"numeric_ranges":{"cost_gbp":{"max":162.5,"min":89.75,"range":72.75},"usage_kwh":{"max":580.25,"min":320,"range":260.25}},"column_cardinality":{"status":2,"cost_gbp":3,"usage_kwh":3,"customer_id":3,"billing_period":1}},"max_fields":25,"max_records":1000,"schema_fields":["billing_period","cost_gbp","customer_id","status","usage_kwh"],"recommended_next_step":"continue with descriptive_stats for general summaries or process_capability when real spec limits exist"},"confidence":0.66}},"exampleRequest":{"schema":{"status":{"type":"string","required":true,"allowed_values":["paid","pending","overdue"]},"cost_gbp":{"max":500,"min":0,"type":"number","required":true},"usage_kwh":{"max":2000,"min":0,"type":"number","required":true},"customer_id":{"type":"string","required":true},"billing_period":{"type":"string","required":true,"max_length":7,"min_length":7}},"context":"Energy billing records for audit validation","records":[{"status":"paid","cost_gbp":125.3,"usage_kwh":450.5,"customer_id":"CUST001","billing_period":"2024-01"},{"status":"pending","cost_gbp":89.75,"usage_kwh":320,"customer_id":"CUST002","billing_period":"2024-01"},{"status":"paid","cost_gbp":162.5,"usage_kwh":580.25,"customer_id":"CUST003","billing_period":"2024-01"}]},"tags":["x402"],"displayCostAmount":"0.01","displayCostAsset":"USDC","priceDynamic":false,"priceHint":null,"priceStatus":"priced","priceSource":"settled","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.001","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.001","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm__YKO5tRrCpBn8tp3lD9Yb","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.001","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Performs deterministic flat-JSON dataset audit checking for missingness, invalid values, duplicates, cardinality, and numeric ranges","exampleAgentPrompt":"Run a full data quality audit on this flat JSON dataset and tell me about any missing values, duplicate rows, invalid entries, cardinality issues, and numeric fields that fall outside expected ranges.","exampleUseCases":null,"resultDescription":"A structured JSON report detailing: missingness counts and percentages per field, invalid value instances, duplicate record counts, cardinality statistics per column, and numeric range violations — all computed deterministically with no probabilistic inference.","failureModes":["Non-flat (nested) JSON structure returns schema validation error","Empty dataset returns trivial audit with zero counts","Malformed JSON returns parse error","Extremely large dataset may exceed payload limits","Non-numeric fields passed as numeric columns return type mismatch error"],"whenToPreferThis":"Use this endpoint when you need deterministic, reproducible data quality checks on a flat JSON dataset — specifically when you need missingness, duplicate, cardinality, and range analysis in a single call. Prefer this over probabilistic or ML-based validators when audit reproducibility and exact counts matter, such as in compliance pipelines or before loading data into a database.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-09-14T12:35:57.239Z","isFirstParty":false}