Skip to main content
Solved

Signature control | Status code 400

  • September 19, 2022
  • 5 replies
  • 71 views

Dennis van Leeuwen
Hero
Forum|alt.badge.img+12

đź“– It would be nice if the documentation were expanded to explain how to set up the signature component. 

Signature control

 
I have 2 columns signature and signature_file with data type NVARCHAR(MAX). Column "signature" with a domain with user interface control "Signature". The other column "signature_file” is used as storage column.  

 

âť—When placing a signature in the Universal GUI I get a bad request error message. 

Request Method: PATCH | Status Code: 400

 

Best answer by Vincent Doppenberg

Hello Dennis,

The signature column should be (n)varchar, as this is where the file name will be stored. The signature_file column should be varbinary, as this is where the file data will be stored. Your domain with the signature control type is really just like another domain with a database storage configuration. The only difference is the control type used to upload/download/display the file.

I hope this helps.

View original
Did this topic help you find an answer to your question?
This topic has been closed for comments

5 replies

Jasper
Superhero
  • 678 replies
  • September 20, 2022

Hi Dennis,

The signature control outputs a PNG image, so you should at least use a VARBINARY field instead of NVARCHAR. Does this fix the problem?


Dennis van Leeuwen
Hero
Forum|alt.badge.img+12

Hi Jasper, 

I changed the column where the data should be stored (signature_file) to VARBINARY(MAX). 

VARBINARY(MAX)

What data type and control do you recommend for the field where the user will capture his signature? Now it's als VARBINARY(MAX) without control. 

 

Unfortunately, this did not fix the problem đꙄ. Uploading a .PNG file from the Windows GUI also results in NULL values. 


Forum|alt.badge.img+4

Hello Dennis,

If you click one of the requests with a 400 status code and then navigate to the Response tab, do you see an error reason there?


Dennis van Leeuwen
Hero
Forum|alt.badge.img+12

Hi Vincent, 

🚩Invalid value 'signature-signature-bf6ae27e-cb39-46de-a11a-1dc4e61de136.png' for property 'signature'.


Forum|alt.badge.img+4

Hello Dennis,

The signature column should be (n)varchar, as this is where the file name will be stored. The signature_file column should be varbinary, as this is where the file data will be stored. Your domain with the signature control type is really just like another domain with a database storage configuration. The only difference is the control type used to upload/download/display the file.

I hope this helps.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings