Tag: json

  • Store JSON in Oracle CLOB

    JSON can be stored as Oracle CLOB data. DBBlobEditor can help you to store JSON as Oracle CLOB data: Batch import JSON files into Oracle CLOB Batch export Oracle CLOB to JSON files

  • Store JSON in DB2 CLOB

    JSON can be stored as DB2 CLOB data. DBBlobEditor can help you to store JSON as DB2 CLOB data: Batch import JSON files into DB2 CLOB Batch export DB2 CLOB to JSON files

  • Batch import JSON files into Access MEMO

    Want to batch import JSON documents into Access MEMO (CLOB) or OLE Object (BLOB) column? Using DBBlobEditor, you can import bulk json files into Access MEMO (CLOB) or OLE Object (BLOB) easily and fast. Step by step, just a few mouse clicks. Support schedule and automate converting task. Support Windows, Linux, macOS. Download DBBlobEditor Windows…

  • View large JSON file smoothly

    Want to open and view huge JSON file? Want to search in huge JSON file, and copy the needed lines in the editor? Big Text File Viewer, is the tool. Fast and Smooth. View Gigabyte-sized JSON file easily, no need to wait long file-loading time. Support Windows, Linux, macOS. Download BigTextFileViewer Windows 64 bit Windows…

  • Save youtube playlist to JSON file

    Want to save youtube playlist to JSON file? Using Data File Converter, a desktop tool, you can retrieve youtube playlist to JSON file easily and fast, no need to program, just a few mouse clicks! Support Windows, Linux, macOS Please download and install Data File Converter. Save youtube playlist to JSON file Click “Start a…

  • Split an array of nested JSON objects

    I see a post https://stackoverflow.com/questions/67607384/split-an-array-of-nested-json-objects-using-jq, the poster gave an example JSON file: { “storeId”: “1412”, “templateCheck”: [ { “rom”: 37, “updateDate”: “2021-05-09 07:53:17”, “lhb”: “2021-05-09 06:32:41”, “templateCode”: “REGULAR”, “lId”: “50-19-78-5C”, “sk”: “830066”, “skUpdateDate”: “2020-07-21 05:37:07”, “battery”: 30, “status”: 1 }, { “rom”: 37, “updateDate”: “2021-05-09 07:54:02”, “lhb”: “2021-05-09 06:32:41”, “templateCode”: “REGULAR”, “lId”: “50-1B-FE-6E”, “sk”: “740541”,…

  • Format multiple JSON files into one CSV for NTFS on OpenSea

    If you want to format multiple JSON files into one CSV for NTFS on OpenSea, you can try Data File Converter, just in a few mouse clicks. 1. Open Data File Converter, select “Files” – “JSON”, “File” – “CSV”. 2. Choose OpenSea JSON metadata files folder. Config JSON options. Custom JSON columns. 3. Set CSV…

  • Convert nested JSON to CSV

    I see a post Convert nested JSON to CSV or table, the poster have JSON data like this: menu1.json {“menu”: { “id”: “file”, “value”: “File”, “popup”: { “menuitem”: [ {“value”: “New”, “onclick”: “CreateNewDoc()”}, {“value”: “Open”, “onclick”: “OpenDoc()”}, {“value”: “Close”, “onclick”: “CloseDoc()”} ] } }} He want to convert it to CSV or table like this:…

  • Convert JSON with attributes to CSV

    I want to convert some NFT metadata JSON files to CSV for opensea. JSON data like this: { “name”: “5”, “description”: “”, “external_url”: “”, “image”: “5.png”, “attributes”: [ { “trait_type”: “Background”, “value”: “DOT-6” }, { “trait_type”: “Luckbox”, “value”: “3” } ], “properties”: { “files”: [ { “uri”: “5.png”, “type”: “image/png” } ], “category”: “image”, “creators”: []…

  • Convert nested JSON with nested arrays to CSV

    I see a post Convert nested json with nested arrays in csv. The poster have this JSON data: [ { “aggregate_result”: [], “explain”: “”, “key_with_document”: [ { “document”: { “creation_date”: 1643342434, “expiration_date”: 2053342527, “modification_date”: 1643342527, “revision”: 4, “struct”: { “MatchResponse”: [ { “adRefId”: “e6040-c8dcdb165993”, “addrRefId”: “city_list:0”, “MatchCode”: “REGI_ADDR_BLOCK”, “maxScore”: 0.9968223809704663 }, { “adRefId”: “800-3c7a04dc8d3f”, “addrRefId”:…