Looking for JSON script for Microsoft Teams LISTS. I have a column called 'In House Washing' for example that is set to Date type. I would like the script to make the below happen:

- if there is no date make it white background with black writing

- if the date is within the 0-14 day range make it pastel green with dark green writing

- if the date is within 15-25 day range make the box pastel yellow with dark yellow writing

- if the date is within 25-30+ day range make the box make it pastel red with dark red writing

Have one that semi works but around the wrong way... Bit of a noob but slowly getting it.. maybe
Much appreciate the help!!

Reposting this from Bsky: Hi! I'm a second-year PhD student at the University of Utah, and our lab is conducting its first study! It's a short paid interview study on data serialization formats (like YAML, JSON, and others). Do you have any thoughts? We'd love to hear them!

https://bsky.app/profile/havoc-lab.bsky.social/post/3lfxxocz52225

If we look at the enormous amount of serialization & configuration formats out there, it seems to me that they either are a swing and a miss or they try to go beyond what I feel such a format should do. After doing tons of research recently on the state of things, I question why out of all these options, nothing really scratches my itch. I like JSON for a lot of reasons over just about everything else, but it has its issues for configuration. I have started looking at defining a derived json format.

https://github.com/LostTime76/vscode-jsonp/tree/main

Hey everyone!

I recently made a little tool called JviewSON, and I thought it might come in handy for anyone who works with JSON files regularly. It’s simple and designed for viewing and analyzing JSON files without any unnecessary extras.

A few key features:

• Displays JSON data in a clean and easy-to-read structure.
• Built-in search to help you find what you need fast.
• Automatically updates if the JSON file changes in the background.
• It’s view-only, so no risk of accidentally editing your data.

If you’re curious, you can check it out on itch.io, where you can also run a browser-based version without downloading:
https://pocdev.itch.io/jviewson

Or if you prefer to dig into the code (made in Godot) here’s the GitHub repo:
https://github.com/andreas-volz/JviewSON

Would love to hear what you think or if you have any ideas for improvement!

I'm working on a WordPress site that features a digital calendar, where the admin can add events for each month (from January to December 2025). The issue I'm facing is that, while the admin successfully adds events to specific date (e.g.: A "work gathering" event on January 27, 2025), only some users, including some admins, are able to see these events on the calendar. Others don't see anything, even though the events are added correctly. It's not just users; even some admins are experiencing this problem.

The site uses WordPress with the Visual Builder to manage the calendar, and the events are properly added on the backend. However, it seems the events are not consistently displaying for the public. I suspect the issue might be related to how data is being handled in local storage or JSON formatting. Specifically, I believe the use of JSON.stringify() to save event data might be causing some conflicts, especially if the data is being retrieved inconsistently across users.

It seems like the issue might be that some browsers or users are loading old or cached event data that hasn't been properly updated or stored. Could this be a problem with how JSON data is being serialized, stored or accessed from local storage? Or might it be related to how different browsers handle JSON?

Has anyone experienced something similar or have any ideas on how to fix it? Any advice on properly handling JSON data with JSON.stringify() or issues with local storage would be greatly appreciated!

This is the code for the digital calendar (only important part):

     let isAdmin = false;
        let currentYear = new Date().getFullYear();
        let currentMonthIndex = new Date().getMonth();

        function loadStoredContent() {
            const storedContent = localStorage.getItem('calendarContent');
            return storedContent ? JSON.parse(storedContent) : {};
        }

        function saveStoredContent(content) {
            localStorage.setItem('calendarContent', JSON.stringify(content));
        }

        // Load stored content on page load
        const storedContent = loadStoredContent();

        function displayCalendar(year, monthIndex) {
            const month = months[monthIndex];
            calendarYear.textContent = year;
            calendarMonth.textContent = month.name;
            calendarGrid.innerHTML = '';

            const firstDayOfMonth = new Date(year, monthIndex, 1).getDay();
            for (let i = 0; i < firstDayOfMonth; i++) {
                const emptyBox = document.createElement('div');
                emptyBox.classList.add('calendar-day');
                calendarGrid.appendChild(emptyBox);
            }

            for (let day = 1; day <= month.days; day++) {
                const dayBox = document.createElement('div');
                dayBox.classList.add('calendar-day');

                const dayNumber = document.createElement('div');
                dayNumber.textContent = day;
                dayNumber.classList.add('day-number');

                const dayContent = document.createElement('textarea');
                dayContent.classList.add('day-content');
                dayContent.setAttribute('readonly', true);

                if (storedContent[`${year}-${monthIndex}-${day}`]) {
                    dayContent.value = storedContent[`${year}-${monthIndex}-${day}`];
                }

                if (isAdmin) {
                    dayContent.removeAttribute('readonly');
                    dayContent.classList.add('admin');
                } else {
                    dayContent.setAttribute('readonly', true);
                    dayContent.classList.remove('admin');
                }

                dayContent.addEventListener('input', () => {
                    storedContent[`${year}-${monthIndex}-${day}`] = dayContent.value;
                    saveStoredContent(storedContent);
                });

What I tried:

1. I checked how events are saved and retrieved using localStorage and JSON.stringify().
2. I cleared the browser cache and reset the localStorage too see if that resolved the issue.
3. I consulted ChatGPT for guidance, thinking there might be a problem with how JSON.stringify() is used or how data is parsed for users. ChatGPT suggested that I double-check whether the data is properly serialized and whether it's being accessed in the same way across all users.
4. I also confirmed that the admin roles are set correctly and tried accessing the site with admin privileges.

What I expected: I expected that after saving the events in localStorage using JSON.stringify(), the events would be displayed consistently for all users, including public visitors and admins.

What actually happened: While admin users can see the events without issue, others (along with regular users) cannot see any events. The events are not being loaded for some users, and there are some error messages in the console, but I don't think they're directly related to the issue of visibility. The problem persists even after troubleshooting steps, and there is no clear connection between the errors and the main event visibility problem.

Running an Avalanche node and getting

" couldn't configure flags: While parsing config: invalid character '{' after top-level value" Error after adding some text to my .json config file.

The file originally was just this

{

"public-ip-resolution-service": "opendns"

}

No error in its original form. However i added this comment to it and it now produces the above error.

{

"public-ip-resolution-service": "opendns"

}

{

// .. other configuration

"track-subnets": "eYwmVU67LmSfZb1RwqCMhBYkFyG8ftxn6jAwqzFmxC9STBWLC"

}

Anny idea what's causing this?

Looking for something that will convert downloaded Facebook messenger json file to something readable that shows the dates and times of messages. The ones I've found on google search convert to html showing a number string.

Need for court purposes, of course.

Ok, I have tried this and as far as I can see…it is formatted properly….but not functioning. This is supposed to calculate elapsed time from a given date field.

{ "$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json", "elmType": "div", "txtContent": "=floor((Number(@now)-Number([$DateHRNotified]))/10006060*24))" }

Can anyone help out? This is just the first function. I then need it to stop counting when another field is populated and check the value against that field calculating the data elapsed between submission and completion.

I am in over my head, but help is scarce.

Hi,

I am looking for huge json file which contains product attributes like ID, name etc.
I checked internet but I could not find a decent one. I need something like 1000+ products at least. Planing to use Elastic search. Looking for data to do testing and finding bottlenecks on my api.

Sorry if this is wrong board. And thanks in advance

The Great Format Fight: A Digital Brawl

In the cold, steel-lined File Format Arena, the top tools in tech gathered for the ultimate battle royale. Each represented its specialty, its pride, and a massive ego to match. The lights dimmed, and the crowd of developers leaned forward as the fight began.

Round 1: JSON Mayhem

jq darted into the ring first, sleek and nimble. “I cut JSON like butter!” it declared, slicing a JSON file into a perfect tree structure with a single command.

But Python, the versatile generalist, landed a jab. “You’re fast, jq, but I transform, analyze, and visualize—watch this!” It whipped out Matplotlib charts from a JSON dataset, dazzling the crowd.

Not far behind, Postman marched in, slamming its API-testing tools. “Who needs you two when I fetch JSON straight from the source?” It hurled a volley of HTTP requests, hitting both Python and jq squarely.

The JSON round ended with all three standing, but jq staggered under Python’s flexibility and Postman’s firepower.

Round 2: The CSV Bloodbath

Excel strutted in next, blinding the audience with its shimmering interface. “Bow before the king of spreadsheets!” it roared, crushing a CSV into pivot tables.

Then came awk, old but lethal. “I don’t need your bells and whistles,” it growled, slicing columns and summing rows in milliseconds. Excel stumbled, not built for raw speed.

But CSVKit, the lightweight champion, dove in. “Efficiency, gentlemen!” It blasted both with a perfectly parsed dataset and clean output, sending Excel sprawling to the ropes. Awk nodded in grudging respect but remained on its feet.

Round 3: PDF Pandemonium

The hulking Adobe Acrobat stomped into the ring, cracking its knuckles. “Who else can touch the PDF domain like me?” It flexed with annotations, merging, and form-filling.

But Ghostscript, the shadowy assassin, emerged from the dark corners of the arena. “I’m faster, leaner, and I’ve been destroying PDFs since you were a prototype.” Acrobat fought back, bloated but powerful.

Python, returning with its PyPDF library, sneakily joined the fray, ripping text from a PDF. Acrobat tried to counter, but Ghostscript delivered a critical blow, leaving Acrobat limping out of the arena.

Final Round: The All-Format Frenzy

In the climactic battle, PowerShell entered, the jack-of-all-trades. “I can handle everything—JSON, XML, CSV—bring it!” It threw a flurry of commands, stunning the others.

Python, ever-adaptable, dodged the attack and countered with regex-powered transformations, calling in Pandas for reinforcements.

But suddenly, Vim—yes, Vim—jumped in from nowhere. “File formats? Who cares? I’ll edit anything!” It disoriented PowerShell and Python with its cryptic key bindings and lightning-fast operations.

The arena fell silent as jq, still standing, whispered, “I may be a one-trick pony, but I’ve mastered my trick.” It delivered a razor-sharp JSON transformation, forcing Vim and Python to retreat.

The Winner?

As the dust settled, a bruised and battered Python raised its hand. Versatile, adaptable, and a jack-of-all-formats, it was the last one standing. But in the crowd, whispers of admiration spread for each tool’s unique prowess. They all had their strengths, and in Techville, there’s room for them all.

Except for Excel. Excel got booed on the way out.

hello everyone, im fairly new to code and modding and i am having an issue with JSON when i wasn't before and i need some help. i will add the JSON list that i am trying to add to my server for mods. I have used a JSON verify tool and it tells me on line 5 that my comma is not in the right place or just not there? here is my error code.

Error: Parse error on line 5:
...version": "1.1.0"},{"modId": "595
----------------------^
Expecting 'EOF', got ','

not sure what to do, i was able to copy and past 2 hours ago no issue now i cant. any help would be greatly appreciated!

{

	"modId": "5965550F24A0C152",

	"name": "Where Am I",

	"version": "1.1.0"

},

{

	"modId": "595F2BF2F44836FB",

	"name": "RHS - Status Quo",

	"version": "0.10.3948"

},

{

	"modId": "5F272AEAF9A987FD",

	"name": "BM-21",

	"version": "1.0.7"

},

{

	"modId": "62CCD69DD17E4F2F",

	"name": "AKI CORE",

	"version": "1.0.3"

},

{

	"modId": "6276E6E3CC97A22B",

	"name": "AUS\_CORE",

	"version": "0.1.9"

},

{

	"modId": "61A4DBDB102D96BF",

	"name": "More vehicles to RU conlfict",

	"version": "1.0.0"

},

{

	"modId": "59D64ADD6FC59CBF",

	"name": "Project Redline - UH-60",

	"version": "1.4.1"

},

{

	"modId": "59BA048FA618471A",

	"name": "Shrapnel",

	"version": "1.1.6"

},

{

	"modId": "5E389BB9F58B79A6",

	"name": "SpaceCore",

	"version": "1.2.27"

},

{

	"modId": "60ED3CC6E7E40221",

	"name": "Sikorsky MH60 DAP Project",

	"version": "0.6.27"

},

{

	"modId": "632F26E1CEA68DFB",

	"name": "Humvee With TOW",

	"version": "1.0.1"

},

{

	"modId": "5E193315C8E82019",

	"name": "M2 Bradley Fighting Vehicle",

	"version": "1.0.7"

},

{

	"modId": "5994AD5A9F33BE57",

	"name": "Game Master FX",

	"version": "1.0.94"

},

{

	"modId": "59673B6FBB95459F",

	"name": "BetterTracers 2.0",

	"version": "2.0.3"

},

{

	"modId": "5F2944B7474F043F",

	"name": "Disable Game Master Budgets",

	"version": "1.0.1"

},

{

	"modId": "629B2BA37EFFD577",

	"name": "WCS\_Armament",

	"version": "1.0.72"

},

{

	"modId": "60B6F67B12B5DB3B",

	"name": "AddModVehiclesToPool",

	"version": "0.0.7"

},

{

	"modId": "5F1EE615E7AE3106",

	"name": "BGONE",

	"version": "1.1.25"

},

{

	"modId": "5AAF6D5352E5FCAB",

	"name": "Project Redline - Core",

	"version": "1.2.5"

},

{

	"modId": "6273146ADFE8241D",

	"name": "AH6M",

	"version": "1.1.14"

}

Hey everyone! I recently launched CompareJSONs.com – a free online platform with a bunch of JSON-related tools (e.g., JSON Compare, JSON Minifier, JSON to CSV, JSON Redactor, etc.). My main goal is to make developers’ and data analysts’ lives easier by providing quick, browser-based solutions for JSON tasks.

I’d love to hear your feedback, suggestions, or feature requests on the site. Specifically:

1. Ease of Use: Are the tools straightforward and intuitive?

2. Tool Variety: Are there any JSON utilities you'd like to see added or improved (e.g., more advanced CSV customization, JSON syntax highlighting)?

3. Performance & Security: Each tool runs locally in your browser, ensuring data privacy. Does this approach meet your needs, or do you have concerns?

4. UI/UX: What do you think of the design, layout, and responsiveness on desktop vs. mobile?

Any thoughts, critiques, or improvement ideas would be greatly appreciated. Thank you in advance for helping me make CompareJSONs.com better for everyone!

Hey guys, new here and completely new to json. I'm trying to make an iOS shortcut to add an entry to my notion database using a notion api. It's not working, and obviously there's a multitude of things that could be going wrong. However, when I run the shortcut, it says there's an error parsing the json. I copied the formatting of my properties straight from notion, so if there's something wrong with the json format I'd assume it's obvious and one of you fine people could help me figure it out. I'll paste the json in a comment below. Thank you to anyone who can help!

Tem um mod no minecraft, eu queria fazer alguma alteraçoes nele, mas, quando fui na pasta do mod e achei os jsons para editar, quando eu abria eles, apareciam umas coisas malucas e nao o codigo. alguem poderia me ajudar?

segue a imagem do que aparece: https://prnt.sc/2wP5oE9Z7A4I

Hi, currently working on a project where I need a json file. However, I’m trying to work with one that has a decent amount of nested dictionaries and arrays. I’ve been looking everywhere for one to use.

Anyone have any json files they mind sharing

i am using a notion database with api in flutterflow and the parsed json data shows the content is rich text and doesn't parse the content , what can i do so the flutterflow parse this rich text from the notion database , which i can reference further in my web app

https://preview.redd.it/txmhugicr64e1.png?width=587&format=png&auto=webp&s=e3c0a4360429b5bfb587b9da8158a0123aca4854

Compare Jsons

https://codeyogi.dev/compare-json

Hi there,

First off, I’m brand new to this kind of thing, I have no background in coding or any real knowledge on the subject. My team has a checklist of repeated objectives that we complete every day, in order to keep better track of those items, I am attempting to write an adaptive card to be automatically posted daily (payload is below). Ultimately what I’m am wanting to do -and this might not be possible so please me know if that is the case - but I would like to have the hidden input.toggles/input.text reveal themselves based on the input.toggle’s value. So when Task1 is complete, Subtask1 shows up etc etc.

I’ve scoured the internet and cannot find a template or something that has been done like this before and all the videos and schema or sites I did through have been dead ends as well. You’re my last hope Reddit.

{     "type": "AdaptiveCard",     "version": "1.5",     "body": [         {             "type": "TextBlock",             "text": "Daily Checklist",             "weight": "Bolder",             "size": "Medium"         },         {             "type": "TextBlock",             "text": "Please mark the tasks as you complete.",             "wrap": true         },         {             "type": "Input.Date",             "id": "Date"         },         {             "type": "Input.Toggle",             "id": "task1",             "title": "Run Alt Address Report",             "valueOn": "Complete",             "valueOff": "Incomplete"         },         {             "type": "Input.Toggle",             "title": "Sent to HD",             "id": "Subtask 1",             "isVisible": false,             "$when": "${task1==complete}",             "valueOn": "Complete",             "valueOff": "Incomplete"         },         {             "type": "Input.Toggle",             "id": "task2",             "title": "Review and Submit LS Bot Errors",             "valueOn": "Complete",             "valueOff": "Incomplete"         },         {             "type": "Input.Number",             "placeholder": "Number of Errors Sent",             "id": "Errors Amount",             "$when": "${task2==Complete}",             "min": 0,             "isVisible": false         },         {             "type": "Input.Toggle",             "id": "task3",             "title": "Review N Cases",             "valueOn": "complete",             "valueOff": "incomplete"         },         {             "type": "Input.Number",             "placeholder": "Number of N Cases",             "id": "NCase Amount",             "min": 0,             "$when": "${task3==Complete}",             "isVisible": false         },         {             "type": "Input.Toggle",             "title": "Sent to HD",             "isVisible": false,             "id": "Subtask2",             "$when": "${NCase Amount<=0}",             "valueOn": true,             "valueOff": false,         },         {             "type": "ActionSet",             "actions": [                 {                     "type": "Action.Execute",                     "title": "Update Checklist"                 }             ]         }     ],     "$schema": "http://adaptivecards.io/schemas/adaptive-card.json" }

I have an online tool to convert JSON to SQL. Sometimes its just easier to query in SQL. Appreciate any feedback, criticisms, comments or request for features.

Heres a link explaining the usage and motivation https://sqlbook.io/s/8M0l9

And another that examines a sample dataset of Nobel Prize winners https://sqlbook.io/s/8M0lA

Hi all! I'm using jq for some JSON processing and ran into the above error.

Produces the error:
jq -n 'sqrt(4)'

Work just fine:
jq -n '4 | sqrt'
jq -n 'pow(4; 0.5)'

Am I just missing something or should I just use pow instead of sqrt?

imm not sure why but i feel like excited and eager to learn JSON, im business student that works in ERP System. FYI, i never learn or know about JSON, i just know its a programing language , is it? and i want to try learn by myself day by day. hopefully i will love it LOL!! i just want to add on my skills and i love to learn new things :) any tips for beginner with zero background for me?

Hey r/JSON,

If you’ve ever had to process complex JSON responses from APIs, you know how difficult it can be to manage nested data or filter results efficiently. That’s one of the reasons we built 'jx', a tool that allows you to use JavaScript syntax for JSON manipulation, speeding up development for anyone familiar with the language.

Key Features:

• API Response Handling: Easily filter, map, and transform API responses in JavaScript.
• Production-ready: Written in Go for memory safety and stability.
• Familiar Syntax: Use JavaScript instead of learning jq’s syntax for faster onboarding.

Here’s an example of how 'jx' simplifies working with nested data:

jq: jq '.users[] | select(.active == true) | .profile.email'

jx: jx 'this.users.filter(user => user.active).map(user => user.profile.email)'

If you regularly work with APIs, you’ll find 'jx' faster to pick up and deploy in production environments. You can find more examples and the full documentation on GitHub: github.com/TwoBitCoders/jx. Let me know how it works for you!

Hello,

I have a huge json data file (300+ MB) that I have opened in OK JSON and I am trying to get about 200 specific observations so that I can put it into SPSS for analysis. Each observation has different sub details that I want to save as well (see image)

I have some limited experience with creating syntax in SPSS and Stata, but I do not have experience using things like Python (which is downloaded onto my computer) or R. For some reason, OK JSON will not let me delete the other observations and the file is too big to import into excel.

If anyone has any advice, that would be much appreciated!

https://preview.redd.it/jzjs9gkj8cyd1.png?width=1110&format=png&auto=webp&s=a791db3c6774c50bb905dc1ac4d04e1eb2f003b1

I have a .Net object that is a List(Of Actions), where Actions is a CRUD record from a DB. So for instance you might have a delete object with a key, or an update with a key and a List(Of FieldChanges).

As the outermost object is an array, I wrote some JSON using StringBuilder like this...

[
"delete": {"key":12345},
"delete": {"key":54321},
"update": {"key":54321,"field":"Name","value":"Bob Smith"},
etc...
]

JSONLint, an online tool, tells me this is invalid because of the [ ]. Is that true? Does the outermost object in the file have to be a { } collection? If so, how would you handle this case?

I am also curious if this is non-canonical as they are individual entries inside. Would it be "more correct" to do this...
[
"delete": [
{"key":12345},
{"key":54321}
]
"update": [
{"key":54321,"field":"Name","value":"Bob Smith"},
etc...
]
]

Or is it just a matter of personal choice?

Guys currently I have assigned to work which involves reading a pdf document using json file and capturing certain fields what exactly am I doing ? I am new to this so just asking

I have searched many places but I was not able to find an answer. May be it does not exist? I am not sure. Please help.

I have this Oracle SQL code:

declare
    json_obj   JSON_OBJECT_T;
    json_arr   JSON_ARRAY_T;
begin
    -- initialize
    json_obj := json_object_t('{"PHONE_NO":[]}');
    json_arr := json_array_t('[]');

    json_arr := json_obj.get_array('PHONE_NO');

    -- start loop here
    json_arr.append(phonenumber_n);
    -- end loop here

    json_obj.put('NAME', 'JOHN');
    l_return := json_obj.to_string();

The output is like this: -- assuming 2 phone numbers found

{"PHONE_NO":[1235551111, 1235552222], "NAME": "JOHN"}

While this is all good, but what if there is no phone number found in the loop. It will look like this:

{"PHONE_NO":[], "NAME": "JOHN"}

However, I wanted it to look like this:

{"NAME": "JOHN"}

Where do I put the 'ABSENT ON NULL'? Do I manipulate in the L_RETURN?

Thank you very much.

(I hope I got the formatting correct.)