I feel like I'm doing something silly causing this problem, but here goes.

I am working on setting up a python workflow/api to use the bulk api with. I have been successful in our live account with reads. But using the sandbox keeps throwing errors about  <exceptionMessage>Invalid session id</exceptionMessage> 

Here's the code.
 

#!/usr/bin/env python
import os

from time import sleep
from simple_salesforce import Salesforce
from salesforce_bulk import SalesforceBulk


password="XXXX"

# * sandbox -- True if you want to login to `test.salesforce.com`, False
#                      if you want to login to `login.salesforce.com`.
sandbox=True

username="XXX@XXXXXXXXXXXXXX.com.SANDBOX_NAME"
security_token="REDACTED"

def get_contacts(bulk):
    job = bulk.create_query_job("Lead", contentType='CSV')
    batch = bulk.query(job, "select Id,FirstName,LastName,Company from Lead")
    while not bulk.is_batch_done(job, batch):
        sleep(10)
    bulk.close_job(job)

    for row in bulk.get_batch_result_iter(job, batch, parse_csv=True):
        print row   #row is a dict


if "__main__" == __name__:
    sf = Salesforce(username=username, password=password,
                    security_token=security_token, sandbox=sandbox)
    bulk = SalesforceBulk(sessionId=sf.session_id, host=sf.sf_instance)
    get_contacts(bulk)

It authenticates and the sf object has a session/session_id. The bulk query fails with the stacktrace below. If I toggle sandbox to false and drop the sandbox name off the email address, I can run this code against production data and it works.

I'm pretty much diving right in here, so don't assume I know much about salesforce. Any feedback is appreciated. I kind of feel like there's something I'm missing with the sf_instance coming back from the login. But... I'm not sure what.
 

salesforce_bulk.salesforce_bulk.BulkApiError: [400] Bulk API HTTP Error result: <?xml version="1.0" encoding="UTF-8"?><error
   xmlns="http://www.force.com/2009/06/asyncapi/dataload">
 <exceptionCode>InvalidSessionId</exceptionCode>
 <exceptionMessage>Invalid session id</exceptionMessage>

 

I am very new to development in SalesForce.  

 

There is a standard field on account called Last Activity which says the date of the last activity.  I would like to know what type of activity the last activity was (email, call, voicemail, etc).

 

Can anyone give me some pointers on how to begin developing to create this new field?

 

All help is very much appreciated.

I feel like I'm doing something silly causing this problem, but here goes.

I am working on setting up a python workflow/api to use the bulk api with. I have been successful in our live account with reads. But using the sandbox keeps throwing errors about  <exceptionMessage>Invalid session id</exceptionMessage> 

Here's the code.
 

#!/usr/bin/env python
import os

from time import sleep
from simple_salesforce import Salesforce
from salesforce_bulk import SalesforceBulk


password="XXXX"

# * sandbox -- True if you want to login to `test.salesforce.com`, False
#                      if you want to login to `login.salesforce.com`.
sandbox=True

username="XXX@XXXXXXXXXXXXXX.com.SANDBOX_NAME"
security_token="REDACTED"

def get_contacts(bulk):
    job = bulk.create_query_job("Lead", contentType='CSV')
    batch = bulk.query(job, "select Id,FirstName,LastName,Company from Lead")
    while not bulk.is_batch_done(job, batch):
        sleep(10)
    bulk.close_job(job)

    for row in bulk.get_batch_result_iter(job, batch, parse_csv=True):
        print row   #row is a dict


if "__main__" == __name__:
    sf = Salesforce(username=username, password=password,
                    security_token=security_token, sandbox=sandbox)
    bulk = SalesforceBulk(sessionId=sf.session_id, host=sf.sf_instance)
    get_contacts(bulk)

It authenticates and the sf object has a session/session_id. The bulk query fails with the stacktrace below. If I toggle sandbox to false and drop the sandbox name off the email address, I can run this code against production data and it works.

I'm pretty much diving right in here, so don't assume I know much about salesforce. Any feedback is appreciated. I kind of feel like there's something I'm missing with the sf_instance coming back from the login. But... I'm not sure what.
 

salesforce_bulk.salesforce_bulk.BulkApiError: [400] Bulk API HTTP Error result: <?xml version="1.0" encoding="UTF-8"?><error
   xmlns="http://www.force.com/2009/06/asyncapi/dataload">
 <exceptionCode>InvalidSessionId</exceptionCode>
 <exceptionMessage>Invalid session id</exceptionMessage>

 

Is there any way to get the profile name of logged in user without querying the user object.

 

I know the following solution:

 

String usrProfileName = [select u.Profile.Name from User u where u.id = :Userinfo.getUserId()].Profile.Name;

 

Instead of this I want to save 1 query so if there is any method to get the profile name in apex without firing the query please let me know.

 

Thanks,