API endpoint for listing a user's domains?

[Copprhead]

I'm experimenting with the API for managing a user's emails. For creating an email address, I need to know which domains the user has available. The API endpoints for domains apparently all need admin permissions, but I only have the user's api key, not an admin api key. Is there some way to list only the user's domains with user api key privileges?

[d00p]

https://docs.froxlor.org/latest/api-guide/commands/subdomains.html#subdomains-listing

This is the corresponding endpoint for customers (which lists all of the customers domains)

[Copprhead]

perfect, thanks!

[Copprhead]

Now I would like to only get the domains that are email-domains. So I tried with sql_search:

{
    "header": {
        "apikey": "{{apikey}}",
        "secret": "{{secret}}"
       
    },
    "body": {
        "command": "SubDomains.listing",
        "params": {
            "sql_search": {
                "isemaildomain": {
                    "op": "=",
                    "value": "1"
                }
            }
        }
    }
}

But this gives a 500 with message

SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'isemaildomain' in where clause is ambiguous

What am I doing wrong?

[d00p]

as the domain listing connects multiple tables, try d.isemaildomain as field

[Copprhead]

Thanks, that works.