I cannot figure out the AQL component of a CSV asset import for my life.
I have a list of People already imported (Name, email, status)
I want to import a list of Projects and map the Project Principal to a People record. The CSV has a field called ProjectPrincipal, which has an email address. This email corresponds to a record already loaded in People Assets.
In the import mapping, I consistently get an error Invalid AQL.
This is the AQL statement. "Project Principal" = objectType = "People" AND "Email" = "${ProjectPrincipal}"
What am I doing wrong?!