Hi, I’m trying to understand how to use "Where" and "Having" in the Ahrefs connector.
According to the AHrefs docs, I should be able to reference a column tld in table tlds:
However, I’m stymied as to how to pull that off inside the connector. I’ve tried a handful of variations, but all produce errors:
=Dump(Connector("Ahrefs.RefDomainsbyTLDType","randomdomain.com","domain","tld=""com""",,"TLD,TLDRefDomainCount",FALSE))
=Dump(Connector("Ahrefs.RefDomainsbyTLDType","randomdomain.com","domain","tld=com",,"TLD,TLDRefDomainCount",FALSE))
=Dump(Connector("Ahrefs.RefDomainsbyTLDType","randomdomain.com","domain","TLD=com",,"TLD,TLDRefDomainCount",FALSE))
=Dump(Connector("Ahrefs.RefDomainsbyTLDType","randomdomain.com","domain",,"!substring(tld,""org"")","TLD,TLDRefDomainCount",FALSE))
See image:
Thanks for any help!
Rich