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

1 answer to this question

Recommended Posts

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...