The value is too large to fit in the column data area of the buffer.
Action:
When getting columns from the REST Source, the following error message is received:
Error Message:
"The value is too large to fit in the column data area of the buffer."
Solution:
You can right click on Rest Source and go to Advanced editor.
From the input output columns for external and output column change the DataType for the problematic column.
The max limit for length is 4000 for DT_WSTR and if any larger than 4000 then you can use DT_NTEXT and then try and see if that fixes the issue.
Book a Presales Call
Related Articles
The value is too large to fit in the column data area of the buffer.
Action: When getting columns from the REST Source, the following error message is received: Error Message: "The value is too large to fit in the column data area of the buffer." Solution: You can right click on Rest Source and go to Advanced editor. ...The value is too large to fit in the column data area of the buffer.
Action: When getting columns from the REST Source, the following error message is received: Error Message: "The value is too large to fit in the column data area of the buffer." Solution: You can right click on Rest Source and go to Advanced editor. ...The value is too large to fit in the column data area of the buffer.
Action: When getting columns from the REST Source, the following error message is received: Error Message: "The value is too large to fit in the column data area of the buffer." Solution: You can right click on Rest Source and go to Advanced editor. ...I see a response returned from the web service, but the preview in REST Source does not show any data.
CozyRoc Rest Source Component allow you to Read data from REST API. The developer can quickly extract response data from the desired endpoint using HTTP Method (GET, POST) and Output into columns data in preview tab. In this article, we will walk ...How to dynamically set a user parameter in a REST Connection.
Create a REST Connection with a custom configuration to use for our example. Let’s start by creating a REST Connection configuration that has authentication with two user parameters. We will set their values dynamically from variables using an ...