Hi Peter, I read the documentation already before and tested different options with no luck. Query grammar only gives you syntactical options but not semantical so it doesn't say which operators are valid for which fields. I tested *IS NULL *and couple of other approaches but I had no luck getting only rows where *advertising_channel_sub_type *is not set.
Also I guess that the *NOT IN* operator shouldn't implicitly exclude NULL values. If you would manage to do such a query please let me know. For now we will load all the data from the API and do additional filtering in the backend. Best, Ales On Friday, 29 January 2021 at 08:37:34 UTC+1 adsapiforumadvisor wrote: > Hi Ales, > > You can refer to our Query grammar > <https://developers.google.com/google-ads/api/docs/query/grammar> guide > to know more on what operators you can use, depending on your reporting > requirement. > > Regarding your question about the advertising_channel_sub_type if the > value is not set, you can try and use the *IS NULL* operator. I hope this > helps. > > Best regards, > > [image: Google Logo] > Peter Laurence Napa Oliquino > Google Ads API Team > > > ref:_00D1U1174p._5004Q2BbfhK:ref > -- -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog: https://googleadsdeveloper.blogspot.com/ =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group. To post to this group, send email to adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en --- You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/cd1400c0-9d80-4909-af7b-fc1cb80eaf2fn%40googlegroups.com.
