Page 2 of 2

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

Posted: Thu Jun 01, 2017 4:30 pm
by 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


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

Posted: Thu Jun 01, 2017 7:50 pm
by Serhii Kulibaba

Hello,

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


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

Posted: Fri Jun 02, 2017 7:50 am
by 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


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

Posted: Fri Jun 02, 2017 5:23 pm
by Serhii Kulibaba

It depends on where you use it.

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

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

Image


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

Posted: Thu Jun 15, 2017 10:56 pm
by Bernie

John, did you find a solution to this?


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

Posted: Fri Jun 16, 2017 12:39 am
by 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..


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

Posted: Fri Jun 16, 2017 1:49 am
by Bernie

Thank you so much, John.


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

Posted: Sat Jul 15, 2017 12:15 pm
by 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

    Image

    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

    Image

    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

    Image

  4. Mapping

    mapping before..

    Image

    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


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

Posted: Sat Jul 15, 2017 1:33 pm
by Bernie

Hi John,

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