Hi.
Is someone able to help me with the below error i am getting when veryifing the data, when i hover over the more part it says The data source schema does not match the type mappings: Wrong column type in Appian.spotifycustomer for column paymentDetails. Found: bigint, expected: integer (APNX-2-4056-000). I have checked the database and the data type and it all matches. I cannot amend the payment details from bigint to integer as it comes up with an error due to a query so i am stuck. I am very new to Appian so any help will be greatly appreciated :)
Thank you,
Sarah
Discussion posts and replies are publicly visible
Hi Sarah,
Please checkout this link https://docs.appian.com/suite/help/19.1/Generating_Database_Tables_from_CDTs.html#default-column-types-based-on-xsd-types
Please check your CDT whether the datatype in XSD is specified as mentioned in the table for bigint.