This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
FAQ
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results forย 
Search instead forย 
Did you mean:ย 

SQL Insert from JSON change type and only type

Garrett
New Contributor II

โ€Ž03-24-2021 08:28 AM

Hi All,

I have a Pipeline that takes data from a Rest API and converts it to a SQL database. This is all working and we are able to create the table without having to define the Schema in a mapper (we have hundreds of tables with thousands of fields and it would be very difficult to map them all individually).

My current issue is that when converting from the JSON to SQL Server it is automatically converting the type from string to varchar(8000). We have Japanese characters etc that are being lost because of this conversion. I need to have it be nvarchar(4000) or if the string is >4000 be nvarchar max.

The question is how do I make that conversion without having to map/define each and every field. And at the same time making sure I donโ€™t truncate anything.

Thanks for your help.

0 Kudos
1 REPLY 1

RavNeu
New Contributor II

โ€Ž06-29-2022 07:03 AM

Hi Garrett,
were you able to resolve this?
I have similar situation. I am trying to pull the pipeline execution history using the Rest API and load it into SQL table. Will you be able to share your sample pipeline that is using rest api to pull the data from the source and load into sql table?
I appreciate your help!

0 Kudos