Timeline for How to parse a JSON with missing property name into a db table
Current License: CC BY-SA 4.0
11 events
when toggle format | what | by | license | comment | |
---|---|---|---|---|---|
Feb 14, 2022 at 13:51 | vote | accept | rziya | ||
Feb 14, 2022 at 13:51 | comment | added | rziya | Thanks. I now see the problem... | |
Feb 14, 2022 at 13:34 | comment | added | rziya | This does not work at my end. Both queries return 0 rows. I also added the original JSON. | |
Feb 14, 2022 at 13:20 | history | edited | Zhorov | CC BY-SA 4.0 |
edited body
|
Feb 14, 2022 at 13:10 | comment | added | Anton Grig | It should work with this JSON sample. | |
Feb 14, 2022 at 13:07 | history | edited | Zhorov | CC BY-SA 4.0 |
Spelling
|
Feb 14, 2022 at 13:01 | comment | added | Zhorov |
@rziya, what is the actual JSON content? Note, that path definitions ($.projects ) are case-sensitive and this may explain the 0 rows results.
|
|
Feb 14, 2022 at 13:00 | history | edited | Zhorov | CC BY-SA 4.0 |
Additional edits
|
Feb 14, 2022 at 12:54 | comment | added | rziya | Both return 0 rows for me... | |
Feb 14, 2022 at 12:49 | history | edited | Zhorov | CC BY-SA 4.0 |
Additional edits
|
Feb 14, 2022 at 12:43 | history | answered | Zhorov | CC BY-SA 4.0 |