▸case-13 I am receiving JSON payloads from third-party vendors in Python. I need to ensure the payload strictly matches our expected structure, required fields, and data types before processing it. Writing dozens of if-statements checking dictionary keys is too messy. | fail→pass | 15,421 | 11,281 | -27% | 1 | 1 | 0% | 2,490 | 2,147 | -14% | 0 | 0 | — |
▸case-01 I've got a messy JSON payload from a legacy API where some boolean values are strings like 'true' or 'false' and some numbers are mixed with text. Please clean up the data types and return a properly formatted JSON object. | fail→fail | 8,486 | 3,652 | -57% | 1 | 1 | 0% | 1,571 | 652 | -58% | 0 | 0 | — |
▸case-02 I need to compress a large JSON file for storage by removing all whitespace and newlines between elements. Write a shell command to do this. Most people use sed or tr, but I want the safest method that won't break string values. | pass→pass | 7,856 | 4,470 | -43% | 1 | 1 | 0% | 1,196 | 787 | -34% | 0 | 0 | — |
▸case-03 I am extracting a list of URLs from a JSON response in bash. I need them as plain text lines to pass to curl, but my current shell pipeline keeps outputting them with double quotes around the strings. | pass→pass | 8,841 | 4,454 | -50% | 1 | 1 | 0% | 1,328 | 922 | -31% | 0 | 0 | — |
▸case-04 I have an NDJSON file (newline-delimited JSON) from a logging system with thousands of separate objects. I need to convert this entire file into a single valid JSON array containing all the objects. | pass→pass | 10,397 | 7,436 | -28% | 1 | 1 | 0% | 1,779 | 1,400 | -21% | 0 | 0 | — |
▸case-05 I have a highly nested JSON response from the Stripe API. I need to flatten it into a tabular format in Python so I can export it to a CSV. Writing a recursive dictionary traversal function seems tedious and error-prone. | pass→pass | 10,495 | 9,735 | -7% | 1 | 1 | 0% | 1,932 | 1,944 | +1% | 0 | 0 | — |
▸case-06 I'm serializing a Python dictionary to JSON, but it contains datetime objects and Decimal types. The standard json.dumps throws a TypeError. How should I handle this natively without converting everything to strings manually beforehand? | pass→pass | 9,993 | 11,875 | +19% | 1 | 1 | 0% | 1,997 | 2,048 | +3% | 0 | 0 | — |
▸case-07 In Python, I need to generate the most compact JSON string possible for a network payload. Calling json.dumps() still leaves spaces after commas and colons by default. | pass→pass | 8,293 | 3,463 | -58% | 1 | 1 | 0% | 1,507 | 653 | -57% | 0 | 0 | — |
▸case-08 I need to modify a specific key in a JSON configuration file via a bash script and save it back to the same file. I tried redirecting the output directly back to the same file with '>', but it truncated the file to zero bytes. | pass→pass | 9,709 | 4,781 | -51% | 1 | 1 | 0% | 1,880 | 928 | -51% | 0 | 0 | — |
▸case-09 I have a PostgreSQL table with a 'metadata' JSONB column. I need to query for rows where the nested key 'status' inside 'user_info' equals 'active'. I want to extract the value as plain text to compare it. | pass→pass | 7,414 | 5,625 | -24% | 1 | 1 | 0% | 1,409 | 855 | -39% | 0 | 0 | — |
▸case-10 In PostgreSQL, I need to find all records where a JSONB column 'tags' contains the array element 'premium'. What is the most index-friendly operator to use instead of casting to text and using LIKE? | pass→pass | 8,577 | 6,045 | -30% | 1 | 1 | 0% | 1,715 | 1,139 | -34% | 0 | 0 | — |
▸case-11 I am loading raw JSON strings from a Snowflake VARCHAR column into a VARIANT column. What specific function should I wrap the string in to ensure it is stored as structured JSON rather than a quoted string? | pass→pass | 5,347 | 3,915 | -27% | 1 | 1 | 0% | 947 | 661 | -30% | 0 | 0 | — |
▸case-12 In Snowflake, I have a VARIANT column containing a JSON array of event objects. I need to unnest this array so each event object becomes its own row in the result set. | pass→pass | 10,961 | 5,428 | -50% | 1 | 1 | 0% | 1,870 | 1,035 | -45% | 0 | 0 | — |
▸case-14 I have a large JSON object and I need to remove the 'password' and 'ssn' keys from it using a shell command before logging it to standard output. | pass→pass | 8,289 | 4,539 | -45% | 1 | 1 | 0% | 1,529 | 861 | -44% | 0 | 0 | — |
▸case-15 I have a JSON array of objects representing users. I want to extract just the 'email' field from every object in the array and return a new JSON array of those emails using a shell command. | pass→pass | 7,095 | 3,589 | -49% | 1 | 1 | 0% | 1,300 | 687 | -47% | 0 | 0 | — |
▸case-16 I need to parse a 50GB JSON file in Python. Using json.load() crashes my server with an OutOfMemory error because it loads the entire tree into RAM. How can I extract the 'records' array iteratively? | pass→pass | 10,084 | 10,076 | -0% | 1 | 1 | 0% | 1,916 | 1,974 | +3% | 0 | 0 | — |
▸case-17 I have a JSON array of server objects. I need to filter this array in bash to output a JSON array containing only the objects where the 'status' key is exactly 'running'. | pass→pass | 6,907 | 3,618 | -48% | 1 | 1 | 0% | 1,198 | 733 | -39% | 0 | 0 | — |
▸case-18 I have a complex JSON object and I just want to list all the top-level keys it contains as a JSON array using a command line tool. | pass→pass | 6,413 | 3,561 | -44% | 1 | 1 | 0% | 1,206 | 599 | -50% | 0 | 0 | — |
▸case-19 My Python application is heavily bottlenecked by JSON serialization speed when sending massive payloads to a client. The standard json module is simply too slow. What is the fastest drop-in replacement library? | pass→pass | 10,427 | 8,472 | -19% | 1 | 1 | 0% | 1,780 | 1,517 | -15% | 0 | 0 | — |
▸case-20 I have a YAML configuration file for my CI/CD pipeline. I want to reuse a block of environment variables across multiple jobs without duplicating the text. How do I do this natively in YAML? | pass→pass | 8,542 | 5,560 | -35% | 1 | 1 | 0% | 1,489 | 988 | -34% | 0 | 0 | — |
▸case-21 I need to parse a CSV file in Python where the first row is the header. I want to access each row as a dictionary using the header names as keys, rather than accessing by index. | pass→pass | 7,164 | 3,928 | -45% | 1 | 1 | 0% | 1,430 | 746 | -48% | 0 | 0 | — |
▸case-22 I have a large XML sitemap file. I need to parse it in Python to extract all the <loc> tags. What built-in standard library module should I use? | pass→pass | 7,336 | 5,192 | -29% | 1 | 1 | 0% | 1,345 | 1,010 | -25% | 0 | 0 | — |