Forum | Appery.io

I am trying to store a picture made with the mobile camera in a SQL Server database connected via API Express.

The image is transferred through the body of the restservice.

I found, that the REST Service response can’t exceed the limit of 10241000B which equals roughly 10MB.

The image base64 string that I want to pass through is much smaller than that.
Setting the camera quality and the image size extremely low I can pass about 4000 characters without any problems. So technically it works.

Looking at the size of the pictures I made with "normal" quality settings I measure about 2 MB.

I know that response time according to what plan you have was a topic before.
But passing through a little over 4000 characters seems truly not enough to break the 3 seconds barrier of the plan I am in.

Especially knowing that it worked with bigger images last week.

I do have the feeling the API Express response time is sort of fluctuating.
If that is the case it is not acceptable at all.

I do need to know fast how to handle this since my customers are waiting for a solution for this issues.

Thanks and thank you for your help in advance.

Hello Bernie,

Please clarify, where do you send that string, in the body of the request or ias an URL parameter?

Hello Serhii,
The string is send in the body of the request.
I also shared the project with support.

And here is the API Express url:
https://appery.io/apiexpress/projects...

You send that image in the body parameter newPOI_media_url, but use a full body value as a media_url in your SQL request:

Please use BODY.newPOI_media_url there

Serhii,
Where exactly do I have to use BODY.newPOI_media_url?
If I use it like shown in the blue rectangle of the sreen-shot, the field media_url remains empty.

Please be sure you've sent that parameter correctly. The simplest example is below:

You have to get the string, which you send with a body property "test":

Please let us know your results

Hi Serhii,
Thanks for the hint.
Unfortunately this did not do the trick.

Testing the service with more than a few KB results in the error:

{
"code": "AE009",
"message": "Connection reset",
"status": "BAD_REQUEST",
"details": {
"componentId": "b3733b85-6d0c-4854-86db-ef2f48b433f5",
"componentProperty": null
}
}

This happens with various configurations.
They all work great with tiny data, but won't work wit "normal" data.

Could this eventually be a bug as referred to in a similar post?

If not, then I desperately would need guidance on how to transfer an image from the mobile camera to a external database through API Express.

Feel free to go into the project (ReporterApp) and do the changes necessary.
It is shared with support.

Thanks,
Bernie

.

Serhii,

I just defined the REQUEST BODY like this

{
"newPOI_media_url":""
}

With that I am getting "PARAMS.BODY.newPOI_media_url" at the PROPERTIES END and can use this to parse the data into the database.

But it still run into the same issue.
The error comes up immediately (typically after about 0.2 seconds).
So I don't think it is related to any plan restrictions.

Please, can you get back to your developer team once more.

This is becoming more and more urgent since we fight this one for over 3 days now.

Thank you so much for your help.

Please provide us a link to you API Express service (like https://appery.io/apiexpress/projects...)

Could you also provide us with exact steps to reproduce this issue/problem?