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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Schema Validation erro...
Power Apps
Unanswered

Schema Validation error (type mismatch)-Custom Connector

(0) ShareShare
ReportReport
Posted on by 18

Hi,

Thank you for your time. I'm working with custom connector created from postman collection, but it is throwing below error.

 Property ".rows.Item.fields.field.Item.value" type mismatch, Expected: "string", Actual: "integer".

However, from api response the property "value" can be string or integer, if I define type of "value" as string - integer values are getting populated as blank and vice versa.

Please help me to change swagger file so that "value" property can accept both strings and integers. I tried removing type and making it as blank, tried adding additional properties and other thing but to no avail.

Below is the swagger for ref: highlighted in orange is the property

swagger: '2.0'

info:

  version: 1.0.0

  title: testAPI

  description: testAPI

host: test-dev.ey.com

basePath: /

schemes:

  - https

consumes: []

produces:

  - application/json

paths:

  /grc/api/query:

    get:

      summary: Get Items

      description: Get Items

      operationId: GetItems

      parameters:

        - name: q

          default: >-

            SELECT * FROM [Indicator]

          in: query

          type: string

          required: true

        - name: pageSize

          default: '3'

          in: query

          type: string

          required: true

      responses:

        default:

          description: default

          schema:

            type: object

            properties:

              links:

                type: array

                items:

                  type: object

                  properties:

                    rel:

                      type: string

                      description: rel

                    href:

                      type: string

                      description: href

                    type:

                      type: string

                      description: type

                description: links

              rows:

                type: array

                items:

                  type: object

                  properties:

                    fields:

                      type: object

                      properties:

                        field:

                          type: array

                          items:

                            type: object

                            properties:

                              dataType:

                                type: string

                                description: dataType

                              id:

                                type: string

                                description: id

                              name:

                                type: string

                                description: name

                              hasChanged:

                                type: boolean

                                description: hasChanged

                              value:

                                type: string

                                description: value

                           description: field

                      description: fields

                description: rows

definitions: {}

parameters: {}

responses: {}

securityDefinitions:

  basic-auth:

    type: basic

security:

  - basic-auth: []

tags: []

Categories:
I have the same question (0)

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 796 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 327 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard