Python Connection 예제들

예제 #1

파일: SFDC_labels.py 프로젝트: JavLG/Salesforce_Reporting

def bajadaSFDC(a,ll):

    my_sf = salesforce_reporting.Connection(llaves[0],llaves[1],llaves[2])
    print("Conectado con exito a SFDC.")
    print("http://eu5.salesforce.com/" + llaves[3])

    try:
        SFSF=requests.get("https://eu5.salesforce.com/" + str(llaves[3]))

    except Exception, e:
        print e + (":: No funcionó la request.")

예제 #2

파일: read_all_cases.py 프로젝트: Richard-Barrett/SalesforceCLI

    username=(config['user']['username']),
    password=(config['user']['password']),
    security_token=(config['user']['salesforce_token']))

print(session_id)

# Options
options = Options()
options.add_argument("--headless")
pd.set_option('display.max_rows', None)

# System Variables
today = date.today()
date = today.strftime("%m/%d/%Y")
node = platform.node()
system = platform.system()
username = getpass.getuser()
version = platform.version()

my_sf = salesforce_reporting.Connection((config['user']['username']),
                                        (config['user']['password']),
                                        (config['user']['salesforce_token']))

with open('reports.json', 'r') as f:
    config = json.load(f)

report = my_sf.get_report((config['report']['all_cases']))
parser = salesforce_reporting.ReportParser(report)
report_final = pd.DataFrame(parser.records())
print(report_final)

예제 #3

파일: models.py 프로젝트: kondra50/ixi-TOOLBOX34V1

from simple_salesforce import Salesforce
import salesforce_reporting
import requests, json
from flask import jsonify
from SFDC import dbmodels
sf = Salesforce(username='', password='', security_token='3GKZny4jRWggQ')
analytic_sf = salesforce_reporting.Connection(
    '3MVG99OxTyEMCQ3glBkdKh4SE2HJs4uODXEl2Fux.LFlCzqkgs9Tr8XLqmCvUsOSdsVpbGoj9xhN5f4hpJ2OZ',
    '86072956447270870', 'cgenx.com', 'passKhggQ', 'na13')

report = analytic_sf.get_report('00Oa0000008uK2BEAU',
                                filters=None,
                                details=True)
parser = salesforce_reporting.ReportParser(report)
dict = parser.records()


class Opportunity():
    def __int__(self, AccountId, Amount, CloseDate, OwnerId, FiscalYear,
                CreatedById):
        self.AccountId = AccountId,
        self.Amount = Amount,
        self.CloseDate = CloseDate,
        self.OwnerId = OwnerId,
        self.FiscalYear = FiscalYear,
        self.CreatedById = CreatedById,

    def Load(self):
        try:
            #list=sf.query("SELECT AccountId,Amount,CloseDate,OwnerId,FiscalYear,CreatedById FROM Opportunity ")
            #sf = Salesforce(username='******', password='******', security_token='3GKZny4jRWgmXNUmvFjzKhggQ')

예제 #4

from sqlalchemy import sql, create_engine, text
engine = create_engine('mssql+pymssql://sysdba:[email protected]:1433/ESIDB')
from simple_salesforce import Salesforce
import salesforce_reporting
import requests, json
from flask import jsonify
sf = Salesforce(username='******',
                password='******',
                security_token='3GKZny4jRWgmXNUmvFjzKhggQ')
analytic_sf = salesforce_reporting.Connection(
    '3MVG99OxTyEMCQ3glBkdKh4SE2HJs4uODXEl2Fux.LFlCzqkgs9Tr8XLqmCvUsOSdsVpbGoj9xhN5f4hpJ2OZ',
    '86072956447270870', '*****@*****.**',
    'password123453GKZny4jRWgmXNUmvFjzKhggQ', 'na13')

try:
    mydict = sf.Solution.create({
        'SolutionNote': 'testALM',
        'SolutionName': 'testALM'
    })
except Exception as e:
    print(str(e))

# def FillSFDC7(*mydict):
#        try:
#           with engine.connect() as con:
#             dict=mydict[0]
#             val=dict.values()
#             key=dict.keys()
#             rs = con.execute('INSERT INTO [SFDC7]([Sales Order Number] )'
#                      'values('+ val[0] +')')
#             con.close()

예제 #5

파일: SFDC_labels.py 프로젝트: JavLG/Salesforce_Reporting

def bajadaSFDC(a,ll):

    my_sf = salesforce_reporting.Connection(llaves[0],llaves[1],llaves[2])
    print("Conectado con exito a SFDC.")
    print("http://eu5.salesforce.com/" + llaves[3])

    try:
        SFSF=requests.get("https://eu5.salesforce.com/" + str(llaves[3]))

    except Exception, e:
        print e + (":: No funcionó la request.")


    my_sf = salesforce_reporting.Connection(llaves[0],llaves[1],llaves[2])
    report= my_sf.get_report(llaves[3])

    ### ACA VER

    print(report)
    parser = salesforce_reporting.ReportParser(report)
    parsed=parser.records()
    labels=parser._get_field_labels()
    parsedlabels=[str(labels[x]) for x in range(len(labels))]

    print(parsed)
    print('''\n\n\n''')
    print('''\n\n\n''')
    TABLA=pandas.DataFrame(parsed)
    TABLA.columns = (parsedlabels)

예제 #6

파일: models.py 프로젝트: kondra50/ixi_API34V1

import pysolr

from simple_salesforce import Salesforce
import salesforce_reporting
import requests, json
from flask import jsonify
from SFDC import dbmodels

solr = pysolr.Solr('http://*****:*****@integenx.com',
    'integenx1nqVHADdVuTvNqv7Cgg4FaNqPj', 'na13')

report = analytic_sf.get_report('00Oa0000008uK2BEAU',
                                filters=None,
                                details=True)
parser = salesforce_reporting.ReportParser(report)
dict = parser.records()


class Opportunity():
    def __int__(self, AccountId, Amount, CloseDate, OwnerId, FiscalYear,
                CreatedById):
        self.AccountId = AccountId,
        self.Amount = Amount,
        self.CloseDate = CloseDate,
        self.OwnerId = OwnerId,