Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Connector Development
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: []

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

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >

Featured topics