Hi
I am new to JSON but followed a guide online to import to a sharepoint list from a JSON and using the following:
As you can see the Parse JSON is failing with an error 'Schema Validation failed'
No doubt I have done something wrong so wondering if someone can help. A sample from the json file:
And here is the Schema I am using (I just need to pull the Sec Des and PX Last data only):
Thanks for help.
Plus I just saw, some of your values are integers and not string like:
RC and PX_Last,
so for them change the schema to:
type: ["integer","null"]
Hey @jamesp24
When I pasted the above schema it gave an error on my side as well.
I think the error could be because of the values that are coming null,
like request name is null in both the items above.
So I would suggest you to add this in all the fields in the schema:
type: ["string","null"]
This worked for me, I hope it would work for you too. 🙂
Michael E. Gernaey
497
Super User 2025 Season 2
David_MA
436
Super User 2025 Season 2
Riyaz_riz11
244
Super User 2025 Season 2