"where" condition in Ahref is not working

Support
#1

SEO tools for excel is throwing error when using the “where” condition to exclude blogspot domains from the total ref domains count.

As mentioned here, https://seotoolsforexcel.com/ahrefs/, I used the “!substring” function to exclude Blogspot domains but is not returning the result.
image
This is the formula I used

=@Dump(Connector("Ahrefs.RefDomains","seotoolsforexcel.com","subdomains","!substring(url_from,""blogspot"")","refdomain","asc","RefdomainsTotal",TRUE,1000))

But I am getting this error
Message: where: column 'url_from' not found

Can you please help me with this?

#2

The having condition must reference one of the metrics returned by the API endpoint:

image
image485×686 62.8 KB

#3

I tried that and still getting the same error

seotools
seotools1279×669 136 KB

#4

url_from is not part of the available fields for this API endpoint. You can see the documentation for all fields (columns):
https://ahrefs.com/api/documentation/refdomains