Pulling LabelID from LabelName AWQL

[Ildar Khakimov]

Hello

I'm trying to execute this query:

SELECT LabelId FROM LABEL_REPORT WHERE LabelName='mtl-mansion-for-sale'

But it throws an error:

An error has occurred: [QueryError{reason=INVALID_FROM_CLAUSE, message=}] 

We first get the "CampaignService" which loads the required class using the following snippet:

$campaignService = $user->GetService('CampaignService', ADWORDS_VERSION);

Could you please advise?

Using Adwords PHP library

[Joyce Lava]

Hi Ildar,

If you wish to use AWQL with reports, you should not use any API service. You would have to generate it using reporting configuration. An example code from PHP client library can be found here.

However, if you wish to use AWQL with service calls, then the FROM clause is not needed and the service should be LabelService instead of CampaignService.

Regards,

Joyce, AdWords API Team