Query API Birthdate field

Scott Rogers
Scott Rogers
Name Dropper Facilitator 1
in Blackbaud Financial Edge NXT® APIs

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

  • Bryce Howard
    Bryce Howard
    Third Anniversary First Reply Kudos 1 Name Dropper

    @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

  • Scott Rogers
    Scott Rogers
    Name Dropper Facilitator 1

    @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

  • Bryce Howard
    Bryce Howard
    Third Anniversary First Reply Kudos 1 Name Dropper

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

  • Scott Rogers
    Scott Rogers
    Name Dropper Facilitator 1

    @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.

  • Scott Rogers
    Scott Rogers
    Name Dropper Facilitator 1

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

Categories