Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Error persisting data for table "conversations" #30

Open
LucasSheep opened this issue Mar 26, 2019 · 2 comments
Open

Error persisting data for table "conversations" #30

LucasSheep opened this issue Mar 26, 2019 · 2 comments

Comments

@LucasSheep
Copy link

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":"

Responding via Email with meeting link to book in time.
",
"body_text":"Responding via Email with meeting link to book in time.",
"id":36008714812,
"incoming":false,
"private":true,
"user_id":36004641603,
"support_email":null,
"source":2,
"category":2,
"ticket_id":2172,
"to_emails":[

  ],
  "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":"

Updated Hubspot
",
"body_text":"Updated Hubspot ",
"id":36009995357,
"incoming":false,
"private":true,
"user_id":36004637235,
"support_email":null,
"source":2,
"category":2,
"ticket_id":2172,
"to_emails":[
"[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":"

Client has signed and onboarding in progress.
",
"body_text":"Client has signed and onboarding in progress. ",
"id":36013528556,
"incoming":false,
"private":true,
"user_id":36004641603,
"support_email":null,
"source":2,
"category":2,
"ticket_id":2172,
"to_emails":[

  ],
  "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

}
]`

@btrigger
Copy link

i'm getting the same error.
Is there any update on this, or recommended config ?

@prijendev
Copy link

@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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants