How to store images returned by REST service

karelh

Hi all,

Hope someone can assist here...

I am trying to make use of a very basic rest service as described in the documentation below:
https://dashboard.clearbit.com/docs#logo-api

You simply send it a url and it returns a PNG file. (Logo of the associate URL).

In my AIM app I have configured (see below) the response as a image/PNG but when I request the service I get the error "Nonexistent attribute:
LogoDOCTYPE"

I tried it with Postman and it returns the image as expected.

Screenshot 2023-01-21 at 18.17.49.jpg
Screenshot 2023-01-21 at 18.21.32.png
Screenshot 2023-01-21 at 18.18.00.jpg

Any suggestions?[

karelh

See below postman result:

Screenshot 2023-01-21 at 18.27.28.jpg

BobK

karelh,

I am not sure this is possible with AwareIM out of the box.

I expose a web service that allows users to send us a picture, and the data for that picture needs to be in a certain format.
See forum post: is it possible to receive picture in a REST service

I am exposing a web service and you are consuming a web service, but I assume the data for the image you are getting back needs to be in a similar format as what I needed. I doubt the web service you are consuming is returning the data in the AwareIM required format.

Jaymer

So what if you receive the image into a plain text field.
And then did an assignment statement in a rule concatenating the file name and the “hash” in front of that text string into picture field.
I wonder what would happen

Jaymer

If you can at least get it into that text field, then you are very close from a very small Java function to set that data into the picture field, in the event that the assignment I spoke of prior, doesn’t work because of syntax.

ThePic = myfunc(filename, base64data)

karelh

HI guys,

Thanks for the ideas and response.

Yeah I have tried that but it does not work either. So from the postman response headers I can confirm that the content returned is image/PNG and when I select this as the content type in AIM a have to select a PICTURE type attribute. See below:

Screenshot 2023-01-23 at 20.37.45.jpg

If I do select a text field, I need to change the content type and if I do I get the below response.

Screenshot 2023-01-23 at 20.39.02.png

PointsWell

karelh wrote
So from the postman response headers I can confirm that the content returned is image/PNG and when I select this as the content type in AIM a have to select a PICTURE type attribute.

That error message is suggesting that Customer.LogoBase is not an attribute of type Picture.

karelh

Hi PointsWell,

Thanks and that is what I also assumed but if I select the correct content type and picture attribute I still get an error "Nonexistant attribute: LogoDOCTYPE"

I also tried moving that picture attribute to the disk instead of the DB but no luck.

aware_support

Could you please send us a BSV for testing and describe how to reproduce the problem in this BSV?

aware_support

Please retest this in build 3125

karelh

HI support,

Do you still need a sample BSV or should we just wait for version 3125?

PointsWell

karelh wrote
HI support,

Do you still need a sample BSV or should we just wait for version 3125?

https://www.awareim.com/dokuwiki/doku.php/changelog/8.8/3125

aware_support

This build is out, so please test the problem in that build.

karelh

Hi support,

I installed the new version but now get the following error when the API is called.

com.bas.basserver.executionengine.ExecutionException: Service provider returned the following error: Internal error. Error writing attribute (conn=25564) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '[B@1dd8fa37 WHERE ID=8249' at line 1

Screenshot 2023-02-10 at 14.40.45.png

aware_support

Can you please send us the BSV to test?