Someone in my company has been sending out surveys from our LiveAgent and Email Cases. They have been passing the UserID and CaseID to the individual survey responses as a hidden field on the survey.
I have been provided a list of a couple thousand Case Id values, and need to get the email address from the Person Account on each of the cases. Because we are using live agent in a retail enviro, we don't always have a customer associated to the case.
I usually look to dataloader to pull based on criteria, but this is way different than anything i've done before.
Should I be looking into SOQL?
Is this easier to do in two stages? Query the list of CaseID to get all the AccountID, then run again to get the email value for each AccountID?
Any help appreciated, feeling the noob vibes again! :)