function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
SimplySfdcSimplySfdc 

using API Web Service from Progress programming language

Hi,

 

Anyone have experience using API Web Service from Progress programming language?

I managed to login, but do not know how to put the serverurl and sessionid into sforceservice.

Any sample will be very appreciated.

Thanks.

 

regards,

sq

JeffGressJeffGress

sq,

 

  You have to modify the soap headers, set up callback procedures, etc.  Not fun.  There's some decent documentation on the progress site.  Get the OpenEdge Development Web Services PDF.  Personally I am looking to do this in .NET now.  Progress just makes it harder than it needs to be, although they do have an ODBC driver out now for salesforce.com.

 

Good luck,

 

    Jeff

 

 

PROCEDURE SOAPSetHeader:
   DEF VAR hXdoc           AS HANDLE     NO-UNDO.
   DEF VAR hXnoderef1      AS HANDLE     NO-UNDO.
   DEF VAR hXnoderef2      AS HANDLE     NO-UNDO.
   DEF VAR hXtext          AS HANDLE     NO-UNDO.
   DEF VAR hHeaderEntryref AS HANDLE     NO-UNDO.
   DEF VAR lcHeader        AS LONGCHAR   NO-UNDO.
  
   CREATE SOAP-HEADER-ENTRYREF hHeaderEntryref .

   /* Create x-doc objects to build header */
   CREATE X-DOCUMENT hXdoc     .
   CREATE X-NODEREF  hXnoderef1 .
   CREATE X-NODEREF  hXnoderef2 .
   CREATE X-NODEREF  hXtext     .

   /* Create the header entry */
   ghHeader:ADD-HEADER-ENTRY(hHeaderEntryref).

   /* Create the header namespace data */
   hXdoc:CREATE-NODE-NAMESPACE(hXnoderef1,gcClientNS,"SessionHeader","ELEMENT").
   hXdoc:CREATE-NODE-NAMESPACE(hXnoderef2,gcClientNS,"sessionId"    ,"ELEMENT").
   hXnoderef1:APPEND-CHILD(hXnoderef2).
   hXdoc:CREATE-NODE(hXtext,"","text") .
   hXnoderef2:APPEND-CHILD(hXtext).
   hXtext:NODE-VALUE = gcsessionid.
   hHeaderEntryref:SET-NODE(hXnoderef1).
     
   lcHeader = hHeaderEntryref:GET-SERIALIZED().
  
   DELETE OBJECT hHeaderEntryref.
   DELETE OBJECT hXdoc.
   DELETE OBJECT hXnoderef1.
   DELETE OBJECT hXnoderef2.
   DELETE OBJECT hXtext.

END PROCEDURE.

SimplySfdcSimplySfdc

Hi Jeff,

 

Thanks a lot for replying my thread.

Can you share a full sample from login to sfdc , then query or insert data to sfdc.

 

cheers,

sq