SOAP error with Web Services

[kmorse]

I'm trying to use Caspio Web Services (with SOAP) to import CSV data into a Caspio Data Table.

Below are two SOAP messages. The only difference between the two SOAP messages sent is one character. The segment that reads "...teaspoon salt, and 1/2 .12345678901" in the GOOD SOAP request. Reads "...teaspoon salt, and 1/2 .123456789012" in the bad SOAP request. That number '2' pushes the SQL insert segment to 257 characters (Character 256, counting the zero)

The field into which I am trying to import this troublesome data is a "Text 64000" data type. Will the 64000 data type not be recognized?

*********************************************************************************************************************

GOOD SOAP message sent :

xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"

xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/"

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xmlns:xsd="http://www.w3.org/2001/XMLSchema"

SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/"

>

-

-

-edited

-edited

-edited

-recipes

-false

-Headline, Intro, Directions, Ingredient1, Ingredient2, Ingredient3, Ingredient4, Ingredient5, Ingredient6, Ingredient7, Ingredient8, Ingredient9, Ingredient10, Ingredient11, Ingredient12, Ingredient13, Ingredient14, Ingredient15, Ingredient16, Ingredient17, Ingredient18, Ingredient19, Ingredient20, Ingredient21, Ingredient22, Ingredient23, Ingredient24, Ingredient25, Ingredient26, Ingredient27, Ingredient28, Ingredient29, Ingredient30, Ingredients, Category, Date, PhotoURL, Photo

-'Stracciatella', 'mrtest5', 'From "Salt to Taste," by Marco Canora with Catherine Young. Serves 6. ', '', '3 large eggs', '2 tablespoons freshly grated Parmigiano- Reggiano plus additional for serving', '1 tablespoon finely chopped fresh flat-leaf parsley Pinch of freshly ground nutmeg Kosher salt and freshly ground black pepper', '4 cups rich homemade broth (vegetable- or meat-based)', '3 large eggs', '2 tablespoons freshly grated Parmigiano- Reggiano plus additional for serving', '1 tablespoon finely chopped fresh flat-leaf parsley', 'Pinch of freshly ground nutmeg Kosher salt and freshly ground black pepper', '4 cups rich homemade broth (vegetable- or meat-based)', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'Beat the eggs and then mix in the cheese and the parsley. Season the egg mixture with nutmeg, 1/2 teaspoon salt, and 1/2 .Beat the eggs and then mix in the cheese and the parsley. Season the egg mixture with nutmeg, 1/2 teaspoon salt, and 1/2 .12345678901 ', '12/02/2009', 'fe02fdcoorec1.JPG', ''

server return message GOOD:

xmlns:xsd="http://www.w3.org/2001/XMLSchema"

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"

>

-

-

-1

==========================================================================

The following SOAP message gets a error return message:

BAD SOAP message sent:

xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"

xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/"

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xmlns:xsd="http://www.w3.org/2001/XMLSchema"

SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/"

>

-

-

-edited

-edited

-edited

-recipes

-false

-Headline, Intro, Directions, Ingredient1, Ingredient2, Ingredient3, Ingredient4, Ingredient5, Ingredient6, Ingredient7, Ingredient8, Ingredient9, Ingredient10, Ingredient11, Ingredient12, Ingredient13, Ingredient14, Ingredient15, Ingredient16, Ingredient17, Ingredient18, Ingredient19, Ingredient20, Ingredient21, Ingredient22, Ingredient23, Ingredient24, Ingredient25, Ingredient26, Ingredient27, Ingredient28, Ingredient29, Ingredient30, Ingredients, Category, Date, PhotoURL, Photo

-'Stracciatella', 'mrtest5', 'From "Salt to Taste," by Marco Canora with Catherine Young. Serves 6. ', '', '3 large eggs', '2 tablespoons freshly grated Parmigiano- Reggiano plus additional for serving', '1 tablespoon finely chopped fresh flat-leaf parsley Pinch of freshly ground nutmeg Kosher salt and freshly ground black pepper', '4 cups rich homemade broth (vegetable- or meat-based)', '3 large eggs', '2 tablespoons freshly grated Parmigiano- Reggiano plus additional for serving', '1 tablespoon finely chopped fresh flat-leaf parsley', 'Pinch of freshly ground nutmeg Kosher salt and freshly ground black pepper', '4 cups rich homemade broth (vegetable- or meat-based)', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'Beat the eggs and then mix in the cheese and the parsley. Season the egg mixture with nutmeg, 1/2 teaspoon salt, and 1/2 .Beat the eggs and then mix in the cheese and the parsley. Season the egg mixture with nutmeg, 1/2 teaspoon salt, and 1/2 .123456789012 ', '12/02/2009', 'fe02fdcoorec1.JPG', ''

server return message BAD:

xmlns:xsd="http://www.w3.org/2001/XMLSchema"

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"

>

-

-

-soap:Client

-{SQL Server error: String or binary data would be truncated. The statement has been terminated.}

-http://bridge.caspio.net/ws/api.asmx

-

-1015

-SQL Server error: String or binary data would be truncated. The statement has been terminated.

==============================================

Any help or advice will be appreciated.

[ChrisJ]

Hello, kmorse.

Think in your situation you had [text_255] field, since for [text_64000] it's working. At least using SOAP emulator. Try to change Data Type in Table Design to correct one.

[Kurumi]

Hi - Just wanted to update everyone that beginning on October 3, 2022, Caspio will deprecate SOAP API Web Services and this option will be removed from API profile creation screen. Existing SOAP applications will continue to function until June 3, 2024. After this date, the Caspio SOAP API will no longer execute. We strongly recommend that you start migrating any existing SOAP calls to Caspio’s REST API to avoid interruption of your applications and benefit from modern API technology. To know more, you can check it here: https://howto.caspio.com/deprecations/deprecation-of-soap-web-service/