Asset import CSV AQL problem - What am I doing wrong?

[Marc Solomon]

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?!

[Christopher Yen]

Hi @Marc Solomon ,

Welcome to the community. I believe the objectType is not necessary in the AQL. Can you try this?

"Email" = "${ProjectPrincipal}"

 It's a bit confusing / not intuitive, I had a better grasp of it when I was trying to set up my import and linking our people object to users on devices so I'm using that as reference right now