• simonjpalmer
  • NEWBIE
  • 0 Points
  • Member since 2007

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 9
    Questions
  • 13
    Replies

Hi,

anyone know how I can get the recordset of the result of running a custom report through the web services API?

Thanks

Simon

Is it possible to get access to views which the user has set up on their Opportunity tab via the Web services API?  If so, how?

What I really want it either:
a) the filter criteria which form the view so I can form a query myself OR
b) the result set of a view

I'm not particularly familiar with these styles of metadata queries and the object structures that describe them.  Is there a good resource out there for learning?

TIA
Simon
I am logging in from a Flex app using the Flex/Air toolkit.  Last week I was getting a security sandbox violation and I have changed my endpoint to refer to a new place and now I am getting the following...

<soapenv:Fault>
<faultcode>
sf:INVALID_LOGIN
</faultcode>
<faultstring>
INVALID_LOGIN: Invalid username, password, security token; or user locked out.
</faultstring>
<detail>
<sf:LoginFault xsi:type="sf:LoginFault">
<sf:exceptionCode>
INVALID_LOGIN
</sf:exceptionCode>
<sf:exceptionMessage>
Invalid username, password, security token; or user locked out.
</sf:exceptionMessage>
</sf:LoginFault>
</detail>
</soapenv:Fault>

I have done all the obvious things like checking password and security token, but I cannot get in from my app - and neither can any of my users.

Anyone have any ideas?
I have been connecting to sf.com to read data for more than a year from my app and suddenly tonight it has stopped working.

I have the following exception (I have deliberately removed the username and password, but I have checked that they are correct and refer to the latest security token. 

This was working fine erlier today and I have changed no code...

Method name is: login
'A997F86A-36E9-DDDC-EC6B-BBEE23101466' producer connected.
'A997F86A-36E9-DDDC-EC6B-BBEE23101466' producer sending message 'B89E5879-D7F7-E91E-2082-BBEE231054DD'
'direct_http_channel' channel sending message:
(mx.messaging.messages::HTTPRequestMessage)#0
  body = "<se:Envelope xmlns:se="http://schemas.xmlsoap.org/soap/envelope/"><se:Header xmlns:sfns="urn:partner.soap.sforce.com"/><se:Body><login xmlns="urn:partner.soap.sforce.com" xmlns:ns1="sobject.partner.soap.sforce.com"><username>simon.palmer@*****.com</username><password>*****</password></login></se:Body></se:Envelope>"
  clientId = (null)
  contentType = "text/xml; charset=UTF-8"
  destination = "DefaultHTTPS"
  headers = (Object)#1
  httpHeaders = (Object)#2
    Accept = "text/xml"
    SOAPAction = """"
    X-Salesforce-No-500-SC = "true"
  messageId = "B89E5879-D7F7-E91E-2082-BBEE231054DD"
  method = "POST"
  recordHeaders = false
  timestamp = 0
  timeToLive = 0
  url = "https://www.salesforce.com/services/Soap/u/11.0"
Method name is: login
*** Security Sandbox Violation ***
Connection to https://www.salesforce.com/services/Soap/u/11.0 halted - not permitted from https://localhost/pm_server/pm/pm-debug.swf
'A997F86A-36E9-DDDC-EC6B-BBEE23101466' producer acknowledge of 'B89E5879-D7F7-E91E-2082-BBEE231054DD'.
'A997F86A-36E9-DDDC-EC6B-BBEE23101466' producer fault for 'B89E5879-D7F7-E91E-2082-BBEE231054DD'.
Comunication Error : Channel.Security.Error : Security error accessing url : Destination: DefaultHTTPS
Error: Request for resource at https://www.salesforce.com/services/Soap/u/11.0 by requestor from https://localhost/pm_server/pm/pm-debug.swf is denied due to lack of policy file permissions.

What has changed?
This is a newbie question... if a user deletes an opportunity what happens to the opportunity record?  It is flagged as deleted and left in place or is it completely deleted?  How do I get a list of deleted opportunity records?  Is that possible?
Downloading and running the latest sample code using as3salesforce.swc I get the following error when logging in (I have obscured my username and password below)...

Login failed:
(com.salesforce.events::ApexFaultEvent)#0
  bubbles = false
  cancelable = true
  context = (null)
  currentTarget = (null)
  eventPhase = 2
  fault = (mx.rpc::Fault)#1
    errorID = 0
    faultCode = "Server.Error.Request"
    faultDetail = "Error: [IOErrorEvent type="ioError" bubbles=false cancelable=false eventPhase=2 text="Error #2032"]. URL: https://www.salesforce.com/services/Soap/u/11.0"
    faultString = "HTTP request error"
    message = "faultCode:Server.Error.Request faultString:'HTTP request error' faultDetail:'Error: [IOErrorEvent type="ioError" bubbles=false cancelable=false eventPhase=2 text="Error #2032"]. URL: https://www.salesforce.com/services/Soap/u/11.0'"
    name = "Error"
    rootCause = (flash.events::IOErrorEvent)#2
      bubbles = false
      cancelable = false
      currentTarget = (flash.net::URLLoader)#3
        bytesLoaded = 0
        bytesTotal = 0
        data = (null)
        dataFormat = "text"
      eventPhase = 2
      target = (flash.net::URLLoader)#3
      text = "Error #2032"
      type = "ioError"
  message = (mx.messaging.messages::ErrorMessage)#4
    body = (Object)#5
    clientId = "DirectHTTPChannel0"
    correlationId = "62A2E11E-D3C1-3091-D22B-10D45BCBB415"
    destination = ""
    extendedData = (null)
    faultCode = "Server.Error.Request"
    faultDetail = "Error: [IOErrorEvent type="ioError" bubbles=false cancelable=false eventPhase=2 text="Error #2032"]. URL: https://www.salesforce.com/services/Soap/u/11.0"
    faultString = "HTTP request error"
    headers = (Object)#6
    messageId = "4837C6BD-A819-0A93-BEAB-10D4619844CC"
    rootCause = (flash.events::IOErrorEvent)#2
    timestamp = 0
    timeToLive = 0
  messageId = "4837C6BD-A819-0A93-BEAB-10D4619844CC"
  target = (null)
  token = (mx.rpc::AsyncToken)#7
    message = (mx.messaging.messages::HTTPRequestMessage)#8
      body = "<se:Envelope xmlns:se="http://schemas.xmlsoap.org/soap/envelope/"><se:Header xmlns:sfns="urn:partner.soap.sforce.com"/><se:Body><login xmlns="urn:partner.soap.sforce.com" xmlns:ns1="sobject.partner.soap.sforce.com"><username>XXXXX</username><password>XXXX</password></login></se:Body></se:Envelope>"
      clientId = (null)
      contentType = "text/xml; charset=UTF-8"
      destination = "DefaultHTTP"
      headers = (Object)#9
        DSEndpoint = "direct_http_channel"
      httpHeaders = (Object)#10
        Accept = "text/xml"
        SOAPAction = """"
        X-Salesforce-No-500-SC = "true"
      messageId = "62A2E11E-D3C1-3091-D22B-10D45BCBB415"
      method = "POST"
      recordHeaders = false
      timestamp = 0
      timeToLive = 0
      url = "https://www.salesforce.com/services/Soap/u/11.0"
    responders = (Array)#11
      [0] (::SalesForceResponder)#12
    result = (null)
  type = "fault"

I followed the instructions and am running my flex app locally under a JBoss server rather than embedding into Salesforce.com as an scontrol.  My username and password are the same ones I use to log in to my developer account so I know they are correct.

Anyone have any idea why?  I am stalled behind ths problem.

Thanks

is anyone successfully using the as3salesforce.swc library and associated examples to connect to salesforce.com?

I can't get past this error on login in the example code...

faultDetail = "Error: [IOErrorEvent type="ioError" bubbles=false cancelable=false eventPhase=2 text="Error #2032: Stream Error. URL: https://www.salesforce.com/services/Soap/u/11.0"]. URL: https://www.salesforce.com/services/Soap/u/11.0" faultString = "HTTP request error"
message = "faultCode:Server.Error.Request faultString:'HTTP request
error' faultDetail:'Error: [IOErrorEvent type="ioError" bubbles=false
cancelable=false eventPhase=2 text="Error #2032: Stream Error. URL:
https://www.salesforce.com/services/Soap/u/11.0"]. URL:
https://www.salesforce.com/services/Soap/u/11.0'"

I am using this in a standalone flex app hosted outside the salesforce framework.  I have adjusted the login code to reflect my username and password but I can't get it to work.

Any ideas?
I am getting compile errors from flex builder about this class being missing.  There was also a message about this having been omitted in previous versions.  How do I fix this for R3_6?
Hi, rank newbie here.  I'm wondering how I would go about getting a reasonable sample set of data for testing creative development ideas against.  It doesn;t have to be meaningful, just referentially correct.  Specifically I am looking for multiple contacts and opportunities.

I have searched this discussion board but to be honest there's a bit too much information and it's a little incoherent. 

Can anyone point me in the right direction.

Thanks

SP
I am logging in from a Flex app using the Flex/Air toolkit.  Last week I was getting a security sandbox violation and I have changed my endpoint to refer to a new place and now I am getting the following...

<soapenv:Fault>
<faultcode>
sf:INVALID_LOGIN
</faultcode>
<faultstring>
INVALID_LOGIN: Invalid username, password, security token; or user locked out.
</faultstring>
<detail>
<sf:LoginFault xsi:type="sf:LoginFault">
<sf:exceptionCode>
INVALID_LOGIN
</sf:exceptionCode>
<sf:exceptionMessage>
Invalid username, password, security token; or user locked out.
</sf:exceptionMessage>
</sf:LoginFault>
</detail>
</soapenv:Fault>

I have done all the obvious things like checking password and security token, but I cannot get in from my app - and neither can any of my users.

Anyone have any ideas?
I have been connecting to sf.com to read data for more than a year from my app and suddenly tonight it has stopped working.

I have the following exception (I have deliberately removed the username and password, but I have checked that they are correct and refer to the latest security token. 

This was working fine erlier today and I have changed no code...

Method name is: login
'A997F86A-36E9-DDDC-EC6B-BBEE23101466' producer connected.
'A997F86A-36E9-DDDC-EC6B-BBEE23101466' producer sending message 'B89E5879-D7F7-E91E-2082-BBEE231054DD'
'direct_http_channel' channel sending message:
(mx.messaging.messages::HTTPRequestMessage)#0
  body = "<se:Envelope xmlns:se="http://schemas.xmlsoap.org/soap/envelope/"><se:Header xmlns:sfns="urn:partner.soap.sforce.com"/><se:Body><login xmlns="urn:partner.soap.sforce.com" xmlns:ns1="sobject.partner.soap.sforce.com"><username>simon.palmer@*****.com</username><password>*****</password></login></se:Body></se:Envelope>"
  clientId = (null)
  contentType = "text/xml; charset=UTF-8"
  destination = "DefaultHTTPS"
  headers = (Object)#1
  httpHeaders = (Object)#2
    Accept = "text/xml"
    SOAPAction = """"
    X-Salesforce-No-500-SC = "true"
  messageId = "B89E5879-D7F7-E91E-2082-BBEE231054DD"
  method = "POST"
  recordHeaders = false
  timestamp = 0
  timeToLive = 0
  url = "https://www.salesforce.com/services/Soap/u/11.0"
Method name is: login
*** Security Sandbox Violation ***
Connection to https://www.salesforce.com/services/Soap/u/11.0 halted - not permitted from https://localhost/pm_server/pm/pm-debug.swf
'A997F86A-36E9-DDDC-EC6B-BBEE23101466' producer acknowledge of 'B89E5879-D7F7-E91E-2082-BBEE231054DD'.
'A997F86A-36E9-DDDC-EC6B-BBEE23101466' producer fault for 'B89E5879-D7F7-E91E-2082-BBEE231054DD'.
Comunication Error : Channel.Security.Error : Security error accessing url : Destination: DefaultHTTPS
Error: Request for resource at https://www.salesforce.com/services/Soap/u/11.0 by requestor from https://localhost/pm_server/pm/pm-debug.swf is denied due to lack of policy file permissions.

What has changed?
Downloading and running the latest sample code using as3salesforce.swc I get the following error when logging in (I have obscured my username and password below)...

Login failed:
(com.salesforce.events::ApexFaultEvent)#0
  bubbles = false
  cancelable = true
  context = (null)
  currentTarget = (null)
  eventPhase = 2
  fault = (mx.rpc::Fault)#1
    errorID = 0
    faultCode = "Server.Error.Request"
    faultDetail = "Error: [IOErrorEvent type="ioError" bubbles=false cancelable=false eventPhase=2 text="Error #2032"]. URL: https://www.salesforce.com/services/Soap/u/11.0"
    faultString = "HTTP request error"
    message = "faultCode:Server.Error.Request faultString:'HTTP request error' faultDetail:'Error: [IOErrorEvent type="ioError" bubbles=false cancelable=false eventPhase=2 text="Error #2032"]. URL: https://www.salesforce.com/services/Soap/u/11.0'"
    name = "Error"
    rootCause = (flash.events::IOErrorEvent)#2
      bubbles = false
      cancelable = false
      currentTarget = (flash.net::URLLoader)#3
        bytesLoaded = 0
        bytesTotal = 0
        data = (null)
        dataFormat = "text"
      eventPhase = 2
      target = (flash.net::URLLoader)#3
      text = "Error #2032"
      type = "ioError"
  message = (mx.messaging.messages::ErrorMessage)#4
    body = (Object)#5
    clientId = "DirectHTTPChannel0"
    correlationId = "62A2E11E-D3C1-3091-D22B-10D45BCBB415"
    destination = ""
    extendedData = (null)
    faultCode = "Server.Error.Request"
    faultDetail = "Error: [IOErrorEvent type="ioError" bubbles=false cancelable=false eventPhase=2 text="Error #2032"]. URL: https://www.salesforce.com/services/Soap/u/11.0"
    faultString = "HTTP request error"
    headers = (Object)#6
    messageId = "4837C6BD-A819-0A93-BEAB-10D4619844CC"
    rootCause = (flash.events::IOErrorEvent)#2
    timestamp = 0
    timeToLive = 0
  messageId = "4837C6BD-A819-0A93-BEAB-10D4619844CC"
  target = (null)
  token = (mx.rpc::AsyncToken)#7
    message = (mx.messaging.messages::HTTPRequestMessage)#8
      body = "<se:Envelope xmlns:se="http://schemas.xmlsoap.org/soap/envelope/"><se:Header xmlns:sfns="urn:partner.soap.sforce.com"/><se:Body><login xmlns="urn:partner.soap.sforce.com" xmlns:ns1="sobject.partner.soap.sforce.com"><username>XXXXX</username><password>XXXX</password></login></se:Body></se:Envelope>"
      clientId = (null)
      contentType = "text/xml; charset=UTF-8"
      destination = "DefaultHTTP"
      headers = (Object)#9
        DSEndpoint = "direct_http_channel"
      httpHeaders = (Object)#10
        Accept = "text/xml"
        SOAPAction = """"
        X-Salesforce-No-500-SC = "true"
      messageId = "62A2E11E-D3C1-3091-D22B-10D45BCBB415"
      method = "POST"
      recordHeaders = false
      timestamp = 0
      timeToLive = 0
      url = "https://www.salesforce.com/services/Soap/u/11.0"
    responders = (Array)#11
      [0] (::SalesForceResponder)#12
    result = (null)
  type = "fault"

I followed the instructions and am running my flex app locally under a JBoss server rather than embedding into Salesforce.com as an scontrol.  My username and password are the same ones I use to log in to my developer account so I know they are correct.

Anyone have any idea why?  I am stalled behind ths problem.

Thanks

is anyone successfully using the as3salesforce.swc library and associated examples to connect to salesforce.com?

I can't get past this error on login in the example code...

faultDetail = "Error: [IOErrorEvent type="ioError" bubbles=false cancelable=false eventPhase=2 text="Error #2032: Stream Error. URL: https://www.salesforce.com/services/Soap/u/11.0"]. URL: https://www.salesforce.com/services/Soap/u/11.0" faultString = "HTTP request error"
message = "faultCode:Server.Error.Request faultString:'HTTP request
error' faultDetail:'Error: [IOErrorEvent type="ioError" bubbles=false
cancelable=false eventPhase=2 text="Error #2032: Stream Error. URL:
https://www.salesforce.com/services/Soap/u/11.0"]. URL:
https://www.salesforce.com/services/Soap/u/11.0'"

I am using this in a standalone flex app hosted outside the salesforce framework.  I have adjusted the login code to reflect my username and password but I can't get it to work.

Any ideas?
Hi, rank newbie here.  I'm wondering how I would go about getting a reasonable sample set of data for testing creative development ideas against.  It doesn;t have to be meaningful, just referentially correct.  Specifically I am looking for multiple contacts and opportunities.

I have searched this discussion board but to be honest there's a bit too much information and it's a little incoherent. 

Can anyone point me in the right direction.

Thanks

SP