{"uid":"cap_O8MnrQcNE7vn7iX-voa7Q","slug":"subscription-activity-numeric-row-ordering-bd17cb2a","name":"Subscription Activity Numeric Row Ordering","description":"Subscription activity - Numeric row ordering: Numeric row ordering for Subscription activity. Up to 200 supplied typed records. Local numeric and data-quality processing; no external enrichment or forecasting. One of 25 profiles or calculations across 20 shared operations in this sector. 0.01 USDC includes one bounded numeric row ordering deliverable.","url":"https://market.datapackvibe.com/x402/assistant-sector-analytics-subscription-activity-sort?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","plan","date","active_accounts","cancellations"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"plan":{"type":"string","default":"","maxLength":80},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"cancellations":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"active_accounts":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","plan":"group-a","row_id":"row-1","cancellations":1,"active_accounts":10},{"date":"2026-10-02","plan":"group-b","row_id":"row-2","cancellations":2,"active_accounts":20},{"date":"2026-10-03","plan":"group-a","row_id":"row-3","cancellations":3,"active_accounts":15},{"date":"2026-10-04","plan":"group-b","row_id":"row-4","cancellations":4,"active_accounts":30}],"maxItems":200,"minItems":1},"field":{"enum":["active_accounts","cancellations"],"type":"string","default":"active_accounts"}}},"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_HgvBSAjoi1VxZkiVQ16YZ","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":"Sorts up to 200 subscription activity records by a specified numeric field (active_accounts or cancellations) and returns them in ordered sequence.","exampleAgentPrompt":"Sort these subscription activity rows by active_accounts — I have 4 records: row-1 (group-a plan, 2026-10-01, 10 active accounts, 1 cancellation), row-2 (group-b plan, 2026-10-02, 20 active accounts, 2 cancellations), row-3 (group-a plan, 2026-10-03, 15 active accounts, 3 cancellations), row-4 (group-b plan, 2026-10-04, 30 active accounts, 4 cancellations).","exampleUseCases":[{"title":"Rank plans by active user count","prompt":"I have a list of subscription activity records across different plans and dates — can you sort them by active_accounts so I can see which rows have the most active users at the top? Here are my records: row-1 (group-a, 2026-10-01, 10 active accounts, 1 cancellation), row-2 (group-b, 2026-10-02, 20 active accounts, 2 cancellations), row-3 (group-a, 2026-10-03, 15 active accounts, 3 cancellations)."},{"title":"Identify highest cancellation periods","prompt":"Sort these subscription activity rows by cancellations so I can identify which dates or plans had the most churn: row-1 (basic plan, 2026-09-01, 500 active accounts, 45 cancellations), row-2 (pro plan, 2026-09-01, 300 active accounts, 12 cancellations), row-3 (basic plan, 2026-09-02, 490 active accounts, 60 cancellations)."},{"title":"Order mixed-plan subscription data for reporting","prompt":"I need to order my subscription data numerically by active_accounts for a report — I have about 8 rows covering two plans (enterprise and starter) across different dates in October 2026, can you sort them and give me the ranked list?"}],"resultDescription":"Returns the submitted subscription activity rows reordered numerically by the specified field (active_accounts or cancellations), preserving all original fields (row_id, plan, date, active_accounts, cancellations) in the sorted sequence.","failureModes":["Missing required fields (row_id, plan, date, active_accounts, cancellations) causes validation error","Exceeding 200 rows returns an error due to maxItems constraint","Invalid date format (not YYYY-MM-DD) triggers pattern validation failure","Invalid field enum value (not active_accounts or cancellations) causes rejection","Empty rows array rejected due to minItems:1 constraint"],"whenToPreferThis":"Use this endpoint when you have up to 200 subscription activity records and need them sorted numerically by either active_accounts or cancellations with no external enrichment or forecasting — ideal for lightweight, local data-quality processing on structured subscription data before downstream analysis or reporting.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-12T00:45:10.019Z","isFirstParty":false,"canonicalSlug":"subscription-activity-numeric-row-ordering-bd17cb2a"}