Collectives™ on Stack Overflow
Find centralized, trusted content and collaborate around the technologies you use most.
Learn more about Collectives
1vote
1answer
85views
JQ - Converting JSON To JSONL Without Losing Original Object Structure
I have JSON that looks like:{ "18003432343": { "04:00:25": {....}, "12:00:25": {....}, }, "18005553332": { "18:11:25": {....}, ...
- 37k
0votes
1answer
73views
JQ - Filtering Out JSON Properties Where Keys Do Not Match Length
I have JSON that looks like:{ "18003432343": ...., "18005553332": ...., "1-3-2025 10:36:41_08941100 AM": ...., "1-3-2025 11:36:41_08941100 AM": ....}...
- 37k
0votes
3answers
104views
Convert JSON file to CSV using jq, expanding nested array data in multiple columns
I need to convert a JSON file to CSV in a bash script, this a sample file:{ "total": 1, "jobs": [ { "deviceData": { "deviceId": "...
- 11
1vote
1answer
92views
Selecting parent objects based on nested child properties
I have a JSON document as a result of scanning a DVD. It contains a TitleList array, each entry of which contains a ChapterList array, each entry of which has a Duration object. I want to select a ...
- 42.5k
2votes
1answer
98views
How do I portably parse a JSON file using libjq?
Consider the following code snippet based on libjq.#include <stdio.h>#include <stdlib.h>#include <jq.h>#include <jv.h>int main(void) { jq_state *jq = jq_init(); ...
- 76.5k
0votes
1answer
89views
How to filter list based on prefix list?
I have a list of hostnames and I want to filter out all hostnames that end in any of a given list of domains.For example for the hostnames["host1.exmaple.org", "host2.example.org"...
1vote
1answer
88views
Converting JSON to CSV using jq with header line
I have a task to convert a JSON file to a CSV with a header at the top. The header has to be in a particular order. So the order of the keys in the JSON file will be in different order than the ...
- 135
1vote
0answers
143views
Add new element stored in a variable to existing JSON array with jq
I am working on creating an adaptive card dynamically. I have the skeleton on the card in JSON and I want to add entries to it (each entry will be a JSON object inside the "body" of the ...
- 8,117
3votes
3answers
129views
Converting a CSV file into a nested JSON file using ./jq
I am hoping I can get an answer on this question. I am using ./jq to convert a CSV file into a file of JSON objects. Each line of the CSV input represents a JSON object. A sample of the CSV input is ...
- 135
3votes
1answer
144views
jq command with several tables in the json path
My (huge) input file has many entries , what I want to extract is structured like that:{ "vulnerabilities": [ { "parentAlert": { "...
- 61
1vote
2answers
64views
How to exclude the elements from one array that exist in another array by some of their properties using jq?
Assuming two json files:a.json[ { "category": "utils", "name": "yq" }, { "category": "utils", "name": &...
- 496
0votes
1answer
69views
JQ will not deep copy arrays with recursive algorithm
When using this algorithm:jq -s 'def deepmerge(a;b): reduce b[] as $item (a; reduce ($item | keys_unsorted[]) as $key (.; $item[$key] as $val | ($val | ...
- 149
-3votes
1answer
157views
Can `jq` be forced` to take slightly malformed JSON body? [closed]
I like using :!pbpaste | jq to see my JSON objects when reading logs in vim.But it often throws the following error with the slightest inconvenience in the JSON body.jq: parse error: Invalid numeric ...
2votes
3answers
187views
Determine if any value exists matching a filter expression while treating an explicit null as existing
I'm trying to determine whether a jq expression refers to no items at all, without collapsing null and empty.As I understand it, .foo? should be identical to try .foo catch empty. Because catch empty ...
- 299k
-1votes
1answer
89views
Join multiple objects with one to many relationship [closed]
Imagine the following data (array of users which can have many roles, each user object has multiple roleIDs referenced and an array of role definitions):{ "users": [ { "id&...
- The Overflow Blog
- Featured on Meta
Hot Network Questions
- When to kill the Passover lamb? Evening on the 14th (beginning of day) or evening of the 14th (end of day)?
- sp_executeSQL does not appear to work for this table update
- Need csvuniq functionality on the command line for CSV with embedded end of line
- Universal approximation of function composition
- PSE Advent Calendar 2025 (Day 14): The Great Paper Caper
- Why does Antigone describe "Justice" as living with the gods "below"?
- How to create smooth random “floating” motion using drivers?
- Doubt on the existence of partial derivative
- \LibertinusInitials no longer recognized using old preamble?
- Rear rack/fender mounting holes
- I published a paper with a calculation I now think is flawed, but the journals will now not let me publish a paper with correction. What should I do?
- Is ritualized confession a sign of a bad culture of failure?
- Native digits in babel without maparabic/mapdigits
- Are there methods for using non-gridbased and non-topdown maps for combat effectively?
- Unexpected behavior in luatexbase.add_to_callback
- Managing a paralyzing backlog of "potentially useful" math papers to read
- What was the first film to reveal the next sequel's title in its credits?
- What syntax are commonly used for labels when pure identifiers are ambiguous?
- Where does the "standard" succubus appearance come from?
- Choosing one specific MeshFunction in Plot3D
- Why can't angular velocity be a scalar quantity in 3D?
- How can materialist philosophers reconcile free will and determinism aka adopting compatibilism?
- What is the "breakeven" annual rent such that you would buy it if the rent exceeds this amount?
- Why did Socrates and Plato become so popular in philosophy unlike other philosophers with similar works?