Example Queries

Queries¶

For any of the below requests, you can copy them as-is into your testing environment of choice - just remember to set the X-API-KEY header.

You can also instantly import the 40 queries below into Postman:

`/companies`¶

Get Companies by Name¶

sourcestack-api.com/companies?name=Salesforce&exact=false

Get a Company by URL¶

sourcestack-api.com/companies?url=salesforce.com&exact=true

Get Companies by Category¶

sourcestack-api.com/companies?category=Agency

Get Companies by Product(s) Use¶

sourcestack-api.com/companies?uses_product=BigCommerce

Note

without exact=True, this will match any of ['BigCommerce', 'Facebook Pixel for BigCommerce', 'BigCommerce Holding Page']

Get Companies by Specific Product Use¶

sourcestack-api.com/companies?uses_product=BigCommerce Checkout&exact=True

Get Companies by Product Category Use¶

sourcestack-api.com/companies?uses_category=Cart

Get the number of English-language companies using Google Analytics¶

sourcestack-api.com/companies?count_only=True&language=en&uses_product=Google Analytics

Get just the urls of WooCommerce Stores selling Marijuana Products¶

sourcestack-api.com/companies?uses_product=WooCommerce&category=Marijuana Products&fields=url&limit=500

`/skus`¶

Get SKUs by Name contains¶

sourcestack-api.com/skus?name=beachball&exact=false

Get SKUs by Parent Company¶

sourcestack-api.com/skus?parent=Turtle Fur&exact=true

Get a SKU by SKU url¶

sourcestack-api.com/skus?url=birdsarentreal.com/products/birdwatching&exact=True

Get SKUs by store URL¶

sourcestack-api.com/skus?url=farmbuyz.com&exact=False

Get SKUs by SKU Category¶

sourcestack-api.com/skus?category=Jewelry

Get the product image links of every BBQ product and write them to Google Sheets¶

sourcestack-api.com/skus?category=BBQ&fields=domain,sku_url,sku_name,sku_price,image_links&export=gsheet

`/jobs`¶

Get Job Posts by Name contains¶

sourcestack-api.com/jobs?name=DevOps&exact=false

Get Job Posts by Name¶

sourcestack-api.com/jobs?name=Platform Engineer&exact=True

Get Job Posts by Parent Company¶

sourcestack-api.com/jobs?parent=Spotify

Get Job Posts by URL¶

sourcestack-api.com/jobs?url=canva.com

Get Job Posts by Specific Product Use¶

sourcestack-api.com/jobs?uses_product=Docker&exact=True

Get Job Posts by Product Category Use¶

sourcestack-api.com/jobs?uses_category=Container Orchestration

Get the Tech Use of every Data Engineer Job Post and write to CSV¶

sourcestack-api.com/jobs?name=data eng&exact=False&fields=post_url,job_name,tags_matched&limit=5000&export=csv

`/products`¶

Get a Product by Name¶

sourcestack-api.com/products?name=Shopify Plus&exact=true

Get Products by Parent Company¶

sourcestack-api.com/products?parent=Cisco&strict=True

Get Products by URL¶

sourcestack-api.com/products?url=www.sendgrid.com&exact=true

Note

to get the most relevant product entry, first try as specific a URL as possible (e.g. here shopify.com/plus is preferable to shopify.com)

Get Products by Category¶

sourcestack-api.com/products?category=CRM

sourcestack-api.com/products?category=eSignature&fields=product_url,domain,twitter_url,linkedin_url&limit=50

`/categories`¶

Get Categories by Name contains¶

sourcestack-api.com/categories?name=Blogging&exact=false

Get Categories by Parent Category¶

sourcestack-api.com/categories?parent=SaaS&exact=True

`/quota`¶

Get the number of SourceStack credits remaining in your account¶

sourcestack-api.com/quota

Advanced Filtering¶

Advanced Filtering queries can combine multiple criteria.

POST /companies where the company is an eCom store and has at least 5 vendors supplying their SKUs¶

[{"field": "sku_vendor_count", "operator": "GREATER_THAN", "value": 5}]

POST /companies where the first date the company was indexed was before Dec 15, 2020¶

[{"field": "first_indexed", "operator": "LESS_THAN", "value": "2020-12-15"}]

POST /skus where the sku_type equals 'shoes'¶

[{"field": "sku_type", "operator": "EQUALS", "value": "shoes"}]

POST /companies where there is a value for `docs_url` (it's NOT NULL)¶

[{"field": "docs_url", "operator": "NOT_EQUALS", "value": "NULL"}]

POST /jobs where the job is based in the country US, UK, or Canada¶

[{"field": "country", "operator": "IN", "value": ["United States", "United Kingdom", "Canada"]}]

POST /companies where the company website language is not in [popular English dialects]¶

[{"field": "language", "operator": "NOT_IN", "value": ["en", "en-us", "en-uk"]}]

POST /products where the product_name contains the phrase 'Cyber'¶

[{"field": "product_name", "operator": "CONTAINS_ANY", "value": "Cyber"}]

POST /jobs where the hiring company's name does not contain the phrases 'bakery' or 'boulangerie'¶

[{"field": "company_name", "operator": "NOT_CONTAINS_ANY", "value": ["Bakery", "Boulangerie"]}]

POST /companies where the company is using Shopify and Klaviyo¶

[{"field": "company_name", "operator": "CONTAINS_ALL", "value": "Shopify, Klaviyo"}]

POST /companies where the company is not an Ad Agency¶

[{"field": "categories", "operator": "NOT_CONTAINS_ALL", "value": ["Advertising", "Agency"]}]

POST /companies where the company was first indexed before Dec 15, 2020 and last indexed after June 15, 2022¶

[{"field": "first_indexed", "operator": "LESS_THAN", "value": "2020-12-15"}, {"field": "last_indexed", "operator": "GREATER_THAN", "value": "2022-6-15"}]