• Another Quickbooks "String or binary data would be truncated" replication error

Another Quickbooks "String or binary data would be truncated" replication error

  • 36Views
  • Last Post 5 weeks ago
  • Topic Is Solved
0
votes
Dominic Santini posted this 24 April 2023

Hi -

We have another issue where the metadata needs to be updated to extend the column length of a field. 

In this case it is the GivenName field of the Customer table. Skyvia creates this field in SQL Server as nvarchar(25).

In our QBO data, this field is the same as FullyQualifiedName (which Skyvia creates with 1000 char limit). It is a combination of project code and account codes in our data, and sometimes exceeds 25 char length.

Please let us know if you can extend the length of this field in your metadata. I would suggest extending the other name fields as well though we are not using them (MiddleName and FamilyName) - 25 characters is quite small.

Thanks.

- Dominic

quickbooks field-truncated
Order By: Standard | Newest | Votes
0
votes
Dominic Santini posted this 24 April 2023

Sorry I forgot to include reference IDs:

Package ID 215075

Run ID 132242621

0
votes
Yevheniia Bilotserkovska posted this 26 April 2023

Hello Dominic.

Thank you for contacting us. 

We have raised a request for our developers to increase the length in the metadata for this field and will let you know when it is done. 

Alternatively, you can temporarily exclude the GivenName field from the replication task.

Best regards,

Yevheniia Bilotserkovska.

0
votes
Yevheniia Bilotserkovska posted this 5 weeks ago

Hello Dominic.

Thank you for your patience and waiting.

We are pleased to inform you that the requested field has been updated according to the documentation:

https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/customer#the-customer-object

Please check and let us know if any questions.

 

Best regards,

Yevheniia Bilotserkovska.

New Ticket
Categories
Popular Tags
Close