Query API Birthdate field

When getting query results through the query API the Birthdate field is coming across as a long string of characters instead of a date. Any thoughts?BirthdateQuery_edit.jpg

Comments

  • @Scott Rogers If I had to guess going off what the YAML says, which is birth date criteria more specific than a full month are not supported, and birth dates cannot be used as sort fields. It also links to this kb

  • @Bryce Howard
    Thank you for your reply. Since I am getting that data via API and do not have direct access to the database how best to decrypt that data? I saw a previous post about using a key to decrypt and running a stored procedure against the database but I do not have access. Thanks

  • @Scott Rogers
    Sorry, but I'm not really sure what you mean. Maybe if you could provide more details on your workflow and goal.

  • @Bryce Howard
    I'm using the query API to get data from a specific query to then generate a separate file to send to a third party invoicing system. When I get the encrypted version of the birthdate from the query result I need to write out the decrypted version of that in my file. What decryption method do I need to use for the encrypted birthdate data?

  • Ashley Moose
    Ashley Moose Blackbaud Employee
    Eighth Anniversary Kudos 5 Name Dropper Participant

    Hi @Scott Rogers - If the formatting mode parameter is left off or set to None when making the POST Query execution job call, birth dates will export encrypted. If you set the formatting mode to UI or Export, it will export in a normal date format.

  • @Ashley Moose That solved the problem. Thank you!!!