web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : ltex28CHNxLkK8ZRH68O1d
Power Automate - Building Flows
Unanswered

Importing JSON file to Sharepoint list - schema validation failed

Like (0) ShareShare
ReportReport
Posted on 25 Apr 2023 09:59:03 by

Hi

I am new to JSON but followed a guide online to import to a sharepoint list from a JSON and using the following:

jamesp24_0-1682416451801.png

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:

jamesp24_1-1682416574230.png

 

And here is the Schema I am using (I just need to pull the Sec Des and PX Last data only):

{
  "type""array",
  "items": {
    "type""object",
    "properties": {
      "DL_REQUEST_ID": {
        "type""string"
      },
      "DL_REQUEST_NAME": {
        "type""string"
      },
      "DL_SNAPSHOT_START_TIME": {
        "type""string"
      },
      "DL_SNAPSHOT_TZ": {
        "type""string"
      },
      "IDENTIFIER": {
        "type""string"
      },
      "RC": {
        "type""string"
      },
      "PX_LAST": {
        "type""string"
      },
      "TICKER": {
        "type""string"
      },
      "SECURITY_DES": {
        "type""string"
      }
    },
    "required": [
      "SECURITY_DES",
      "PX_LAST"
    ]
  }
}

 Thanks for help.

  • Sundeep_Malik Profile Picture
    6,482 on 25 Apr 2023 at 11:26:01
    Re: Importing JSON file to Sharepoint list - schema validation failed

    @jamesp24 

     

    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"]

  • Sundeep_Malik Profile Picture
    6,482 on 25 Apr 2023 at 11:23:50
    Re: Importing JSON file to Sharepoint list - schema validation failed

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2