FileMaker 16 - Encrypting/Decrypting data
FileMaker 16 added a variety of new features designed to support its new ability to interact with web services using JSON. One of those supporting features was the addition of more cryptographic functionality.
Previously, the only native feature available was an MD5 hash. At the time of it being added, it was already out of fashion as a security based feature, but it could be used to compare two things against each other.
By adding new encryption and decryption capabilities, we are now able to encrypt and decrypt data directly within the database itself. This means we can, if desired (and your security policies allow it), store things like credit cards and other sensitive information. While the functions themselves are pretty straight-forward, it’s always nice to know the ins-and-outs of how to implement a feature properly.
Comments
oAuth1.0 Base64 HMAC-SHA1 encryption
Hi Matt,
Love your work!
Could you advise what the correct formula should be to return Base64 HMAC-SHA1?
I use the insert from URL and have no issues accessing from the 'test URL' provided by the application however when trying to generate my own encryption I can't get it to match.
A URL-encoded, base64 HMAC-SHA1 hash of a colon separated string following this structure:
{api_key}:{http method}:{route}:{expires}
Any ideas?
This video is broken
Won't play.
Search Encrypted data.
I would appreciate some help on how to search (portals, sql...) encrypted data?