I have been having trouble finding an appropriate solution for this as I have little experience working with JSON arrays and querying json with JSONata Here is a simplified version of my JSON array: [ { "job":1, "issue":"red", "issuesInJob":50 },…
I have a class called Documents that should have an array of DocumentItem objects and I want them to appear in the json that I want to send to the DB but they're not. I want the backend to display…
I have multiple json files in subfolders, each containing an array of objects with same keys, different values. example: file1.json: [ { "id": 1, "name": "John" }, { "id": 2, "name": "Mary" } ] file2.json: [ { "id": 1, "name":…
Running the below: $ echo '["lorem", "ipsum", "dolor"]' | jq '. | contains(["rem"])' returns true because "rem" is a substring of "lorem". I would like a whole word match, which would disqualify "rem" and only allow one of the three…
Basically, I am trying to list an array in the console like this, I will give an example. config.json { Names: [ "Stewart", "Bob", "Kevin" ] } And then the console would print out once called in a JS file…
I am pulling json from an API but its format is not familiar to me. It looks like this: {"ok": true, "database": "boe_spending", "query_name": null, "rows": [["CITIBANK NA", 99237716.31], ["MARYLAND STATE RETIREMENT & PENSION SYSTEM", 16438857.25], ["DALY COMPUTERS INC", 9314951.79]],…
Here I am trying to implement Ocelot for API Gateway for my multiple micro services. I have Seven Micro services which have lots of API almost 550 APIs. While preparing ocelot.json it is a huge file which seems unmaintainable. For…
I am trying to convert the below json to a markdown table(GitHub docs(.md file)), however not able to do so. { "service_1":"abc-endpoint.vpce.amazonaws.com", "service_2":"def-endpoint.vpce.amazonaws.com", "service_3":"xyz-endpoint.vpce.amazonaws.com" } Command I tried: cat json_file | jq -r '{"NAME": "ENDPOINT_ID"} + . | to_entries[] |…
I'm rather new to JOLT transformations so I'm still having trouble with pretty basic stuff. I have a big JSON payload that I need to simplify by removing most data from it. The only attributes I want to keep are…
I am building a website to visualize the data in table like these: index.html: <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title>Employee Data</title> <!-- Load CSS --> <link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/1.10.25/css/jquery.dataTables.min.css"> <!-- Load Custom CSS --> <style> body { font-family: Arial,…