How to Define "BLOB" dataType of SQL in Appian CDT

mohammedz

Certified Associate Developer

over 8 years ago

Guyz,

I have a table in database with three columns
ID - Number
Document - BLOB
Name - VARCHAR

The Document column is of "BLOB" DataType....
Now I need to create a CDT and Map it to the Table
To do so what should be the dataType in my CDT or XSD Definition

Appreciate ur response....!!!!

Discussion posts and replies are publicly visible

Top Replies

ankitb0003 over 8 years ago +1

I have used the following definition for CLOB, It worked for me. it should be same for BLOB. <xsd:element name="DOCUMENT" nillable="true" type="xsd:string"> <xsd:annotation> <xsd:appinfo source="appian…

0 mohammedz
Certified Associate Developer
over 8 years ago

@stefan
Never mind ....!!
I fixed the issue .. Thanks again for your valuable thoughts ...!!!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Stefan Helzle
A Score Level 3
over 8 years ago

What was the problem?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 mohammedz
Certified Associate Developer
over 8 years ago

I declared three columns and passed two values ... Silly mistake ..human error lolzz
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Stefan Helzle
A Score Level 3
over 8 years ago

OK. Great it works now. Just one question. Why do you store binary documents in DB?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 mohammedz
Certified Associate Developer
over 8 years ago

We need to fetch Bin Doc from external DB, as it is stored der in BLOB Format ...
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Stefan Helzle
A Score Level 3
over 8 years ago

OK, thanks.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Pramod Kumar Reddy Uppula over 5 years ago in reply to Stefan Helzle

Hi All,

We are storing the documents uploaded in an external database and the documents are no where stored in Appian. I need to retrieve the documents from external DB and display them in appian interface. For this, I am using "Receive file from RDBMS BLOB". Can anyone help me in configuring this node.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel