Need to filter leads via the API by the domain of their website

I initially tried to filter the built in website field, but it appears the API doesn’t support that and returns

JavaScript

{ "errors":[ { "status":"400", "title":"filter constraint", "detail":"The filter is not supported.", "source": { "parameter":"filter[website]" } } ]}

1 2 3 4 5 6 7 8 9 10 11 12

{ "errors":[     {         "status":"400",         "title":"filter constraint",         "detail":"The filter is not supported.",         "source":         {             "parameter":"filter[website]"         }     } ]}

To solve this I created a new string field called Website1 and attempted to filter on that using ^ (starts_with), but then I get the following error:

JavaScript

{ "errors":[ { "status":"400", "title":"filter constraint", "detail":"The operator \"starts_with\" is not supported.", "source": { "parameter":"filter[Website1]" } } ]}

1 2 3 4 5 6 7 8 9 10 11 12

{     "errors":[     {         "status":"400",         "title":"filter constraint",         "detail":"The operator \"starts_with\" is not supported.",         "source":         {             "parameter":"filter[Website1]"         }     } ]}

It gets the same result if I use ~ (contains). I have other text fields that I need to search like this also, so I’m happy to use the Website1 field I made and not worry about the built in website field.

Thanks in advance!

Topic

[Andrey YatsenkoModerator]

Hi Hanan,

Multi website support is an enterprise edition feature, if you are an enterprise customer, please submit a question to a customer support portal. Otherwise, we don’t provide any support for implementing enterprise features in a community edition.

Thank you.

• This reply was modified 4 years, 4 months ago by  Andrey Yatsenko.

[hananParticipant]

Hi andrey,

No, I’m not an enterprise customer . I’m not trying to implement it as a multi website field. I saw that wasn’t available. I’m trying to implement it as a simple text field. My question comes down to why I can’t use the ^ or ~ with the API when filtering a normal text field.

[Andrey YatsenkoModerator]

See https://doc.oroinc.com/backend/api/how-to/#advanced-operators-for-string-filter

[hananParticipant]

Amazing! Thank you! My one question is where is Resources/config/oro/api.yml?

I searched for it and found the following:

Shell

[centos@ip-###-##-##-### oroapp]$ sudo find . -name "api.yml" ./vendor/oro/platform/src/Oro/Bundle/AddressBundle/Resources/config/oro/api.yml ./vendor/oro/platform/src/Oro/Bundle/ApiBundle/Resources/config/oro/api.yml ./vendor/oro/platform/src/Oro/Bundle/ApiBundle/Tests/Functional/Environment/api.yml ./vendor/oro/platform/src/Oro/Bundle/ApiBundle/Tests/Unit/DependencyInjection/Fixtures/BarBundle/Resources/config/oro/api.yml ./vendor/oro/platform/src/Oro/Bundle/ApiBundle/Tests/Unit/DependencyInjection/Fixtures/BazBundle/Resources/config/oro/api.yml ./vendor/oro/platform/src/Oro/Bundle/ApiBundle/Tests/Unit/DependencyInjection/Fixtures/FooBundle/Resources/config/oro/api.yml ./vendor/oro/platform/src/Oro/Bundle/AttachmentBundle/Resources/config/oro/api.yml ./vendor/oro/platform/src/Oro/Bundle/CommentBundle/Resources/config/oro/api.yml ./vendor/oro/platform/src/Oro/Bundle/ConfigBundle/Resources/config/oro/api.yml ./vendor/oro/platform/src/Oro/Bundle/EmailBundle/Resources/config/oro/api.yml ./vendor/oro/platform/src/Oro/Bundle/EntityBundle/Resources/config/oro/api.yml ./vendor/oro/platform/src/Oro/Bundle/EntityConfigBundle/Resources/config/oro/api.yml ./vendor/oro/platform/src/Oro/Bundle/IntegrationBundle/Resources/config/oro/api.yml ./vendor/oro/platform/src/Oro/Bundle/LocaleBundle/Resources/config/oro/api.yml ./vendor/oro/platform/src/Oro/Bundle/NoteBundle/Resources/config/oro/api.yml ./vendor/oro/platform/src/Oro/Bundle/OrganizationBundle/Resources/config/oro/api.yml ./vendor/oro/platform/src/Oro/Bundle/ReminderBundle/Resources/config/oro/api.yml ./vendor/oro/platform/src/Oro/Bundle/TagBundle/Resources/config/oro/api.yml ./vendor/oro/platform/src/Oro/Bundle/UserBundle/Resources/config/oro/api.yml ./vendor/oro/marketing/src/Oro/Bundle/CampaignBundle/Resources/config/oro/api.yml ./vendor/oro/marketing/src/Oro/Bundle/MarketingActivityBundle/Resources/config/oro/api.yml ./vendor/oro/crm-task-bundle/Resources/config/oro/api.yml ./vendor/oro/crm-call-bundle/Resources/config/oro/api.yml ./vendor/oro/calendar-bundle/Resources/config/oro/api.yml ./vendor/oro/crm/src/Oro/Bundle/AccountBundle/Resources/config/oro/api.yml ./vendor/oro/crm/src/Oro/Bundle/CaseBundle/Resources/config/oro/api.yml ./vendor/oro/crm/src/Oro/Bundle/ChannelBundle/Resources/config/oro/api.yml ./vendor/oro/crm/src/Oro/Bundle/ContactBundle/Resources/config/oro/api.yml ./vendor/oro/crm/src/Oro/Bundle/ContactUsBundle/Resources/config/oro/api.yml ./vendor/oro/crm/src/Oro/Bundle/MagentoBundle/Resources/config/oro/api.yml ./vendor/oro/crm/src/Oro/Bundle/SalesBundle/Resources/config/oro/api.yml ./vendor/oro/crm/src/Oro/Bundle/TestFrameworkCRMBundle/Resources/config/oro/api.yml ./vendor/oro/commerce/src/Oro/Bundle/CatalogBundle/Resources/config/oro/api.yml ./vendor/oro/commerce/src/Oro/Bundle/FrontendTestFrameworkBundle/Resources/config/oro/api.yml ./vendor/oro/commerce/src/Oro/Bundle/InventoryBundle/Resources/config/oro/api.yml ./vendor/oro/commerce/src/Oro/Bundle/OrderBundle/Resources/config/oro/api.yml ./vendor/oro/commerce/src/Oro/Bundle/PaymentTermBundle/Resources/config/oro/api.yml ./vendor/oro/commerce/src/Oro/Bundle/PricingBundle/Resources/config/oro/api.yml ./vendor/oro/commerce/src/Oro/Bundle/ProductBundle/Resources/config/oro/api.yml ./vendor/oro/commerce/src/Oro/Bundle/PromotionBundle/Resources/config/oro/api.yml ./vendor/oro/commerce/src/Oro/Bundle/RFPBundle/Resources/config/oro/api.yml ./vendor/oro/commerce/src/Oro/Bundle/SaleBundle/Resources/config/oro/api.yml ./vendor/oro/commerce/src/Oro/Bundle/TaxBundle/Resources/config/oro/api.yml ./vendor/oro/commerce/src/Oro/Bundle/WebCatalogBundle/Resources/config/oro/api.yml ./vendor/oro/customer-portal/src/Oro/Bundle/CustomerBundle/Resources/config/oro/api.yml ./vendor/oro/commerce-crm/src/Oro/Bridge/CustomerAccount/Resources/config/oro/api.yml ./vendor/oro/crm-dotmailer/Resources/config/oro/api.yml ./vendor/oro/crm-zendesk/Resources/config/oro/api.yml

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49

[centos@ip-###-##-##-### oroapp]$ sudo find . -name "api.yml" ./vendor/oro/platform/src/Oro/Bundle/AddressBundle/Resources/config/oro/api.yml ./vendor/oro/platform/src/Oro/Bundle/ApiBundle/Resources/config/oro/api.yml ./vendor/oro/platform/src/Oro/Bundle/ApiBundle/Tests/Functional/Environment/api.yml ./vendor/oro/platform/src/Oro/Bundle/ApiBundle/Tests/Unit/DependencyInjection/Fixtures/BarBundle/Resources/config/oro/api.yml ./vendor/oro/platform/src/Oro/Bundle/ApiBundle/Tests/Unit/DependencyInjection/Fixtures/BazBundle/Resources/config/oro/api.yml ./vendor/oro/platform/src/Oro/Bundle/ApiBundle/Tests/Unit/DependencyInjection/Fixtures/FooBundle/Resources/config/oro/api.yml ./vendor/oro/platform/src/Oro/Bundle/AttachmentBundle/Resources/config/oro/api.yml ./vendor/oro/platform/src/Oro/Bundle/CommentBundle/Resources/config/oro/api.yml ./vendor/oro/platform/src/Oro/Bundle/ConfigBundle/Resources/config/oro/api.yml ./vendor/oro/platform/src/Oro/Bundle/EmailBundle/Resources/config/oro/api.yml ./vendor/oro/platform/src/Oro/Bundle/EntityBundle/Resources/config/oro/api.yml ./vendor/oro/platform/src/Oro/Bundle/EntityConfigBundle/Resources/config/oro/api.yml ./vendor/oro/platform/src/Oro/Bundle/IntegrationBundle/Resources/config/oro/api.yml ./vendor/oro/platform/src/Oro/Bundle/LocaleBundle/Resources/config/oro/api.yml ./vendor/oro/platform/src/Oro/Bundle/NoteBundle/Resources/config/oro/api.yml ./vendor/oro/platform/src/Oro/Bundle/OrganizationBundle/Resources/config/oro/api.yml ./vendor/oro/platform/src/Oro/Bundle/ReminderBundle/Resources/config/oro/api.yml ./vendor/oro/platform/src/Oro/Bundle/TagBundle/Resources/config/oro/api.yml ./vendor/oro/platform/src/Oro/Bundle/UserBundle/Resources/config/oro/api.yml ./vendor/oro/marketing/src/Oro/Bundle/CampaignBundle/Resources/config/oro/api.yml ./vendor/oro/marketing/src/Oro/Bundle/MarketingActivityBundle/Resources/config/oro/api.yml ./vendor/oro/crm-task-bundle/Resources/config/oro/api.yml ./vendor/oro/crm-call-bundle/Resources/config/oro/api.yml ./vendor/oro/calendar-bundle/Resources/config/oro/api.yml ./vendor/oro/crm/src/Oro/Bundle/AccountBundle/Resources/config/oro/api.yml ./vendor/oro/crm/src/Oro/Bundle/CaseBundle/Resources/config/oro/api.yml ./vendor/oro/crm/src/Oro/Bundle/ChannelBundle/Resources/config/oro/api.yml ./vendor/oro/crm/src/Oro/Bundle/ContactBundle/Resources/config/oro/api.yml ./vendor/oro/crm/src/Oro/Bundle/ContactUsBundle/Resources/config/oro/api.yml ./vendor/oro/crm/src/Oro/Bundle/MagentoBundle/Resources/config/oro/api.yml ./vendor/oro/crm/src/Oro/Bundle/SalesBundle/Resources/config/oro/api.yml ./vendor/oro/crm/src/Oro/Bundle/TestFrameworkCRMBundle/Resources/config/oro/api.yml ./vendor/oro/commerce/src/Oro/Bundle/CatalogBundle/Resources/config/oro/api.yml ./vendor/oro/commerce/src/Oro/Bundle/FrontendTestFrameworkBundle/Resources/config/oro/api.yml ./vendor/oro/commerce/src/Oro/Bundle/InventoryBundle/Resources/config/oro/api.yml ./vendor/oro/commerce/src/Oro/Bundle/OrderBundle/Resources/config/oro/api.yml ./vendor/oro/commerce/src/Oro/Bundle/PaymentTermBundle/Resources/config/oro/api.yml ./vendor/oro/commerce/src/Oro/Bundle/PricingBundle/Resources/config/oro/api.yml ./vendor/oro/commerce/src/Oro/Bundle/ProductBundle/Resources/config/oro/api.yml ./vendor/oro/commerce/src/Oro/Bundle/PromotionBundle/Resources/config/oro/api.yml ./vendor/oro/commerce/src/Oro/Bundle/RFPBundle/Resources/config/oro/api.yml ./vendor/oro/commerce/src/Oro/Bundle/SaleBundle/Resources/config/oro/api.yml ./vendor/oro/commerce/src/Oro/Bundle/TaxBundle/Resources/config/oro/api.yml ./vendor/oro/commerce/src/Oro/Bundle/WebCatalogBundle/Resources/config/oro/api.yml ./vendor/oro/customer-portal/src/Oro/Bundle/CustomerBundle/Resources/config/oro/api.yml ./vendor/oro/commerce-crm/src/Oro/Bridge/CustomerAccount/Resources/config/oro/api.yml ./vendor/oro/crm-dotmailer/Resources/config/oro/api.yml ./vendor/oro/crm-zendesk/Resources/config/oro/api.yml

[Andrey YatsenkoModerator]

Please read the API documentation carefully. It’s all there. The file could be located at any bundle, as all the files all are merged together at the end.

[Author]

Replies