{"id":46303,"library":"salesforce-cdp-connector","title":"Salesforce CDP Connector","description":"The Salesforce CDP Connector is a Python library that enables SQL-based querying of Salesforce Data Cloud (formerly Customer Data Platform). It provides a friendly Pythonic interface to submit queries via the Data Cloud Query API and retrieve results as pandas DataFrames or GENERIC records. Current version 1.0.20 supports Python >=3.8 and requires authentication via a connected app (client ID, secret, and user token). It is maintained under the Salesforce open source ecosystem.","status":"active","version":"1.0.20","language":"python","source_language":"en","source_url":"https://github.com/forcedotcom/SalesforceCDPConnector","tags":["salesforce","cdp","data-cloud","query"],"install":[{"cmd":"pip install salesforce-cdp-connector","lang":"bash","label":"PyPI install"}],"dependencies":[{"reason":"To return query results as DataFrames","package":"pandas","optional":true},{"reason":"HTTP client for API calls","package":"requests","optional":false}],"imports":[{"wrong":"from salesforce_cdp_connector import SalesforceCDP","symbol":"SalesforceCDP","correct":"from salesforcecdpconnector import SalesforceCDP"}],"quickstart":{"code":"import os\nfrom salesforce_cdp_connector import SalesforceCDP\n\nconnector = SalesforceCDP(\n    client_id=os.environ.get('SF_CLIENT_ID', ''),\n    client_secret=os.environ.get('SF_CLIENT_SECRET', ''),\n    user_token=os.environ.get('SF_USER_TOKEN', ''),\n    api_url=os.environ.get('SF_API_URL', 'https://api.salesforce.com')\n)\n\nresult = connector.query(\"SELECT Id, Name FROM Account LIMIT 10\")\nprint(result)","lang":"python","description":"Minimal example querying Data Cloud. Credentials should be set via environment variables."},"warnings":[{"fix":"Update to use client_id, client_secret, and user_token from a connected app. See migration guide.","message":"Version 1.0.0 changed the authentication from username/password to OAuth2 client credentials. Existing code using username/password will break.","severity":"breaking","affected_versions":"<1.0.0"},{"fix":"Always ensure api_url ends with '/services/data/vXX.X/' or use the default URL pattern.","message":"The SDK does not validate the API URL format; a missing trailing slash may cause unexpected HTTP errors.","severity":"gotcha","affected_versions":"all"},{"fix":"Replace connector.execute_query('...') with connector.query('...').","message":"The method 'execute_query' is deprecated since 1.0.15; use 'query' instead.","severity":"deprecated","affected_versions":">=1.0.15"}],"env_vars":null,"search_vec":"'1.0.20':52 '3.8':55 'api':40 'app':62 'authent':58 'base':16 'cdp':2,6,79 'client':63 'cloud':21,38,82 'connect':61 'connector':3,7 'current':50 'custom':23 'data':20,24,37,81 'data-cloud':80 'datafram':46 'ecosystem':77 'enabl':13 'former':22 'friend':29 'generic':48 'id':64 'interfac':31 'librari':11 'maintain':71 'open':75 'panda':45 'platform':25 'provid':27 'python':10,30,54 'queri':17,34,39,83 'record':49 'requir':57 'result':43 'retriev':42 'salesforc':1,5,19,74,78 'secret':65 'sourc':76 'sql':15 'sql-base':14 'submit':33 'support':53 'token':68 'user':67 'version':51 'via':35,59","created_at":"2026-06-07T12:59:16.613280+00:00","updated_at":"2026-06-07T12:59:16.613280+00:00","problems":{"verify_error":"<string>:1: DeprecationWarning: salesforce-cdp-connector is deprecated and will be removed once salesforce-datacloud-connector reaches GA. Please migrate to salesforce-datacloud-connector. See https://github.com/forcedotcom/salesforce-cdp-connector#migration for migration guidance.\nTraceback (most r"},"ecosystem":"pypi","meta_description":null,"install_score":null,"quickstart_score":null,"quickstart_tag":null,"pypi_latest":null,"cli_name":null,"cli_version":null,"type":"library","homepage":null,"github":null,"docs":null,"changelog":null,"pypi":null,"npm":null,"openapi_spec":null,"status_page":null,"smithery":null,"categories":["analytics","database"],"base_url":null,"auth_type":null,"provenance":{"verified_status":"import_fail","verified_at":"2026-07-03","last_verified":"2026-07-03","next_check":"2026-07-10","install_tag":null}}