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.)

Curious to hear what you think of the approach described in this article:
https://dashjoin.medium.com/json-schema-openapi-low-code-a-match-made-in-heaven-d29723e543ac

It leverages the JSON Schema from an OpenAPI spec to render a form. The form contents is then POSTed to the API.

I can't seem to find any helpful info online. Basically, I have an extremely nested json file in my s3 bucket and I want to run a crawler on it. I've already created a classifier with json path $[*], among other attempts. It always seems go fail on "table.storageDescriptor.columns.2.member.type" saying member must have length less than 131072.

I assume glue is inferring the entire file as one gigantic array and I have no idea where to go from here. Anyone have any cloud experience and can offer some guidance?

I'm looking to create an inventory system that exports to JSON for easy and quick file transfer. It's not like a warehouse size of things. 100 different items maybe.

My question is: would that probably be a relatively small file (a few kb) or would that become quite large (over 1mb) for transferring long distances?

Forgive me for another "help me" post but I'm truly struggling.

At my job i started recently we use two main programs for utility pole loading analysis. One is katapult & the other is SPIDAcal. Shorten visual of work flow for context:

1. Katapult designers design poles
2. SPIDA designers use said designs to design 3D models to stress test

Both have APIs but we are currently entering all the information 1 by 1, extremely unproductive. I have access to both of githubs but can't seem to find the information i'm needing. I have very little experience with any of this but am eager to learn. The biggest hurdle is that the two programs use different identifiers for equipment used. It would be a lot easier if our katapult designers entered all the information katapult requires for ease of export. However, management has decided that this would take too long as they have a higher work load. So, i guess i'm looking for a way to make *something* that can export for katapult, read what its saying and translate it in a way that spidacal understands with minimal errors.

Is this possible? Here are the githubs https://github.com/spidasoftware

I have some GPX data I would like to format into a GeoJSON format pasted in below. The GPX data is in a dataframe in R, with variables longitude, latitude, elevation, attribute type and summary. I would like some code to format the dataframe so the output is like below. With the feature segment generating a list when the attributeType changes.

TLDR: How do I get GPX data in a readable format to be used here here

const FeatureCollections = [{

"type": "FeatureCollection",

"features": [{

"type": "Feature",

"geometry": {

"type": "LineString",

"coordinates": [

[8.6865264, 49.3859188, 114.5],

[8.6864108, 49.3868472, 114.3],

[8.6860538, 49.3903808, 114.8]

]

},

"properties": {

"attributeType": "3"

}

}, {

"type": "Feature",

"geometry": {

"type": "LineString",

"coordinates": [

[8.6860538, 49.3903808, 114.8],

[8.6857921, 49.3936309, 114.4],

[8.6860124, 49.3936431, 114.3]

]

},

"properties": {

"attributeType": "0"

}

}],

"properties": {

"Creator": "OpenRouteService.org",

"records": 2,

"summary": "Steepness"

}

}];

Hi, my capabilities file is as follows

{ "dataRoles": [ { "name": "Category", "kind": "Grouping", "displayName": "Brand" }, { "name": "Measure", "kind": "Measure", "displayName": "Percentage" } ], "dataViewMappings": [ { "categorical": { "categories": { "for": { "in": "Category" }, "dataReductionAlgorithm": { "top": {} } }, "values": { "select": [{ "bind": { "to": "Measure" } }] } } } ], "objects": {}, "privileges": { "data": [ "read" ] } }

I get an error when building of "array should be . privilages"

I've run it through chatgpt to try fix and it cycles between array should be .privelages to object should be privileges[0]

Any ideas ?

Hello everyone,

I'm trying to get the phone numbers and e-mail adresses of all the town halls in France (there are 35 000 of them).
All of these phone numbers and e-mail adresses are public and gathered in a JSON file issued by the government. The JSON file is for all to use, and it's used by common people in databases, digital phone books, etc.
I would like to extract phone numbers and e-mails with the help of some homemade program. The thing is, I am quite noob at programming. I know the very basics, but that's all.

How should I proceed? Is there a programming language better suited for this ? It seems Python is the way to go. Also, can a noob like me achieve something like this? With the help of chatGPT maybe?

Thank you all in advance for your help.

I want to make my expo go react native aplication run on android, but this pops up un expo go:

Uncaught Error: org.json.JSONException: Value <! doctype of type java.lang.String cannot be converted to JSONObject

What can i do??? How can i convert it?

Hi All,

I am trying to update a JSON data in a word document, but when I paste it, it is pasted just as normal data, with the color of key/value pairs removed, just updated as normal text. How can I paste it in proper JSON format, withe key/value pairs highlighted in color, etc.,

Thanks,

Gopi

Hi everyone.
I need to test several JSON files (done from After effects). They work fine in Android, but they don't in IOS. Sending each test to the developer takes a long time. Is there a way to test the files in an IOS environment or simulator from my pc or iPad? (I'm sorry, im a not a programmer, just an animator, so for me this is alien language) thanks.,

Does this mean my phone is being tracked? I don't even know if this is the right place to ask..

{ "title": "Endpoint", "javaType": "com.tmobile.myaccount.consumer.clienttracingconsumer.pojos.ClientSpanEndpoint", "type": "object", "properties": { "serviceName": { "type": "string", "description": "Classifier of this endpoint in lowercase, such as "acme-frontend"" }, "ipv4": { "type": "string", "description": "The text representation of a IPv4 address associated with this endpoint. Ex. 192.168.99.100" }, "ipv6": { "type": "string", "description": "The text representation of a IPv6 address associated with this endpoint. Ex. 2001:db8::c001" }, "port": { "type": "integer" } }, "additionalProperties": false }