Hi,
we have requirement to receive blob type via web api and need to show that as document/image in Appian interface.
I am using receive file from Receive file from RDBMS Blob smart service from pulg-in.
When I add a row in appian DB manually and try to convert to image/document it works fine.
But the issue is when I am trying to send same blob content in web api and trying see document/image after conversion; it says unsupported type.
and in DB noticed the size is also different.
I am using the below PM in web api.
Any web-api content type/code issue ? How to resolve this issue ?
Thanks,
Reetish
Discussion posts and replies are publicly visible
Hi Reetish,
Did you try "Send File to RDBMS Blob" instead of Write to data store entity.
More details here.
https://community.appian.com/b/appmarket/posts/rdbms-blob-utility
Thank you,
Ricky Chaware
It asks document as one of its input. So I wont be able to use it for my requirement.I am using CDT to store the blob type data which I am receiving from external source into Appian DB and then I am trying to convert it into document/image.
Underline xsd as below:<xsd:element name="DOCUMENT" nillable="true" type="xsd:string"> <xsd:annotation> <xsd:appinfo source="appian.jpa">@Column(name="blobAPP", columnDefinition="BLOB")</xsd:appinfo> </xsd:annotation> </xsd:element> <xsd:element name="DOCUMENT_MEDIUM" nillable="true" type="xsd:string"> <xsd:annotation> <xsd:appinfo source="appian.jpa">@Column(name="mediumBlobAPP", columnDefinition="MEDIUMBLOB")</xsd:appinfo> </xsd:annotation> </xsd:element>I am not sure if this is correct way to define CDT for blob type.
I don't think Appian support BLOB data type to be mapped with CDT field because it can contain huge data.
you can find this limitation documented here. https://docs.appian.com/suite/help/20.3/Mapping_CDTs_to_Pre-defined_Database_Tables.html
I would suggest you to have a look at https://docs.appian.com/suite/help/20.3/passing-a-web-api-document-into-a-process-model.html where you can upload a document directly in Appian using web API.
Thanks Ricky. This is a limitation as per the documentation.
I have already tested the other approach as suggested in the the second link. External system is/planning to store documents/images as blob . May be we need to change the design approach.Thanks a lot.