Parse JSON error - Claims information

[Fernanda]

Hello!

I was creating a flow with help of some youtube videos and some other posts, but it is failing now.

What I am doing, is read a User/Group column, get the distinct values and send them an email.

To get the distinct value, I am using: union(body('Seleccionar-Usuario'),body('Seleccionar-Usuario'))

My problem is when I parse JSON.

This is my flow:

For Parse JSON, i took the output from initialize variable, copied it entirely and pasted it to generate the schema.

What am I doing wrong??? can you help me, please?

Thank you!!!

[abm]

Hi @Fernanda 

What's the Parse JSON error you getting?

Thanks

[Fernanda]

Hi @abm !

Here it is:

  {

    "message": "Invalid type. Expected String but got Null.",

    "lineNumber": 0,

    "linePosition": 0,

    "path": "[6].Usuario.Department",

    "schemaId": "#/items/properties/Usuario/properties/Department",

    "errorType": "type",

    "childErrors": []

  },

  {

    "message": "Invalid type. Expected String but got Null.",

    "lineNumber": 0,

    "linePosition": 0,

    "path": "[6].Usuario.JobTitle",

    "schemaId": "#/items/properties/Usuario/properties/JobTitle",

    "errorType": "type",

    "childErrors": []

  }

]

Thanks for your help!!

[abm · Accepted solution]

Hi @Fernanda 

This means Department and JobTitle properties are passing as null. To accept and validate the null in your Parse JSON step you need to edit the current schema to include string and null.

"Department": {

            "type": ["string", "null"]

        },

        "JobTitle": {

            "type": ["string", "null"]

        }

Thanks

[Fernanda]

@abm 

genius!! thanks so much!!! it worked perfectly!