How to store a image base64 from an image asset to sql server database field type CLOB?

[John Lee]

Dear Serhii

I too have issue with uploading the base64.. i do get error with query string too long... it seems that anything over 6K length... Any insight will be great!!
Thank YOU

[Serhii Kulibaba]

Hello,

It seems you send that parameter as an URL parameter. Please send it in the POST's body instead

[John Lee]

Dear Serhii

Good morning to you and thank you so much for your quick response... if possible, could i have an example as to How I would do it?
I have been only using the URL parameter.
Thank YOU always!!

JL

[Serhii Kulibaba]

It depends on where you use it.

Please look at this screenshot how to send them in API Express service:

And this one how to send them in the Appery.io service:

[Bernie]

John, did you find a solution to this?

[John Lee]

Dear Bernie

Good afternoon to you and we are testing the solution at this time (hope to have the result by end of the month)... we will definitely keep you updated...
thank you for your inquiry..

[Bernie]

Thank you so much, John.

[John Lee]

Dear Bernie

Good morning to you and sorry about the delay..
I do believe, we have got it working...
we did bit differently, and will explore further to take full advantage of API service.
I assume, you are already able to take a photo and have the data somewhere..

1. API - Start

   

   in the request body section, i assume, we can have an object, but for this purpose, we have a single parameter which called "BodyParam"

2. API - SQL assign

   

   once you "parse sql parameters", you will be able to select "BodyParam" from the drop down, and choose what is pointed..

3. Data

   Import the API service

   

4. Mapping

   mapping before..

   

   we are mapping the asset (jpg, 100%, 1024x768) to BodyParam.
   Since we are putting the base64 in a body, it does not matter how big the string is...

   If you have any further questions, please feel free to let me know..
   I'm very impressed with how versatile API service is and how it is implemented..
   Thank you for your patience, and Thank Mr. Serhii for pointing us to right direction!!!

   JL

[Bernie]

Hi John,

Thank you so much for the update.
I will give it a shot next week.