Query builder API

[Alexander Hristov]

Hey everyone,

This may come off as a bit strange but I was wondering if you might consider adding something like this. The query builder works in browser and it reads the data from locations such as this and all the processing is done by the browser. The reason for having an API is to automate tests. Hypothetically I could pull those JSON files and implement them on my own, but I'm not sure how much I'd be able to rely on them long term. So as a two part question, would such an API be possible and if not, how much of a leap of faith would it be to use those json files?

Kind regards,

Alex.

[Google Ads API Forum Advisor Prod]

Hi Alex,

Thank you for questions.

The query builder currently can only perform checks when users specify the query or construct the query using the browser.

That said, so I can more accurately capture the feature you are suggesting, could you provide the step by step process of what you are currently imagining so I can create a feature request later on?

Best regards,

Peter Laurence Napa Oliquino Google Ads API Team

ref:_00D1U1174p._5004Q2I08Ds:ref

[Alexander Hristov]

Hi Peter,

OK, so a bit of context: I'm currently dealing with migrating from the old Adwords API. With that in mind, much of the things involve adapting the API to an existing codebase(and a really large one at that), where a lot of the implementations rely heavily on mocking the gRPC services. Having said that, it would be hugely beneficial to be able to validate queries while(/in parralel) when running tests. Effectively some API where I could post a GAQL query, and get a response similar to the one in the qury builder. Generally I don't mind implementing the logic myself from the schemas as those mentioned in the original message but it feels hacky/risky considering it's not official and therefore could potentially change at any given time.

Regards,

Alex.

[Google Ads API Forum Advisor]

Hi Alex,

Thanks for providing some more context. If I understand your request, you are basically looking for a query validation tool in the API, rather than in the browser so that the validation can be approached programmatically. Please let me know if I've misunderstood or if anything else needs to be added to the request.

Regards,
Matt
Google Ads API Team

Matt Google Ads API Team

ref:_00D1U1174p._5004Q2I08Ds:ref

[Alexander Hristov]

Hi Matt,

Yes, indeed, that's exactly what I'm looking for.

Regards,

Alex.

[Google Ads API Forum Advisor]

Hi Alexander,

Thank you for the confirmation and providing more context to your concern.

Allow me to raise a feature request to my team about this, subject for review. For now, please follow our blog as we will post there any updates and new releases about the API.

Regards,

Ernie John Blanca Tacata Google Ads API Team

ref:_00D1U1174p._5004Q2I08Ds:ref

[Google Ads API Forum Advisor]

Hi Alexander,

I appreciate your patience on this concern. I received an update from the team and let me share it to you.

Since the API validates queries when you make requests to the API, there would no longer be a need for additional validation. When making API request and there is an issue there, the API will return an error.

In addition, you can specify, for example, a "LIMIT 1" in the query as well to reduce actual returned results.