Jump to content
  • 0

SOAP error with Web Services


kmorse
 Share

Question

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.

Link to comment
Share on other sites

2 answers to this question

Recommended Posts

  • 0

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/

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...