tap-freshdesk
tap-freshdesk copied to clipboard
Error persisting data for table "conversations"
Using the StitchData FreshDesk integration. From the extraction logs:
Error persisting data for table "conversations": Record 6 did not conform to schema: #/to_emails: #: no subschema matched out of the total 2 subschemas #/to_emails: expected type: JSONArray, found: String #/to_emails: expected: null, found: String
Using StitchData - I performed several full refreshes from FreshDesk without any problems then this problem showed up all of a sudden around 06:19am AEST March 26th. The ticket in question is a closed ticket that hasn't had any updates made to it. Below is the JSON response that appears to be causing the error. The only thing I can think of is the hyphen in the email address? I'm desperate for a fix or workaround, any help appreciated.
`[
{
"body":"
],
"from_email":null,
"cc_emails":[
],
"bcc_emails":null,
"email_failure_count":null,
"outgoing_failures":null,
"created_at":"2018-03-06T13:09:25Z",
"updated_at":"2018-03-24T09:30:18Z",
"attachments":[
],
"source_additional_info":null
},
{
"body":"
"[email protected]" ], "from_email":null, "cc_emails":[
],
"bcc_emails":null,
"email_failure_count":null,
"outgoing_failures":null,
"created_at":"2018-04-04T01:48:19Z",
"updated_at":"2018-04-04T01:48:19Z",
"attachments":[
],
"source_additional_info":null
},
{
"body":"
],
"from_email":null,
"cc_emails":[
],
"bcc_emails":null,
"email_failure_count":null,
"outgoing_failures":null,
"created_at":"2018-05-09T03:11:01Z",
"updated_at":"2018-05-09T03:11:01Z",
"attachments":[
],
"source_additional_info":null
} ]`
i'm getting the same error. Is there any update on this, or recommended config ?
@LucasSheep @btrigger Can you please share a sample record in which to_email
contains a string value?
Above shared records have to_email
value in the list
only.