When using the API https://api.sky.blackbaud.com/query/queries/{queryId}, the email address field has the name "Number". When we receive the CSV after running a query, however, it has the name "Email Number". This is problematic as I need to know which column is the email column for de-duping and for working with emails.

I have two questions:

• Is this intentional? If not, are you able to let us know when it is consistent.

• If it is intentional, are there any other columns like this? We can hardcode this if necessary but if there's an unknown amount of other discrepancies then that's a problem.

I have attached a sample API response and CSV for comparison. Number is the second field in the API response. (Bit odd that I neither upload .json files nor .txt files in this ideas platform - that is why it has been converted to pdf)

fields_api_resp...

results_1.csv

×

Attachments Open full size