Hi,

Our employee data are available in Oracle database and we want to integrate the employee details to our environment. Every day the data should be synchronized and if any new user is added/modified, it should be updated to our environment post synchronization. How can I integrate Oracle with BPM'Online and where can I find any documents/link related to it? 

Thanks,

Anupama

File attachments

Like

2 comments

 

Dear Anupama,

Please find all available options to integrate with bpm'online in the following article:

https://academy.bpmonline.com/documents/technic-sdk/7-8/recommended-int…

Hence, you can use OData protocol, which is a universal for integrations. Also, you can create your own web service in bpm'online using C# and send external request to your side. Please see instruction on how to create your own web service:

https://academy.bpmonline.com/documents/technic-sdk/7-8/how-create-own-…

Regards,

Anastasia

 

 

Thanks Anastasia for sharing the links. 

 

Show all comments
API

I have a few questions about the BPM Data Services.

  1. ​Can I submit CRUD requests in JSON format as HTTP Requests - PUT/GET?
  2. Where can I find the API reference for Rest methods, functions/ syntax?
  3. Any addtional guides or code examples out there, beside the BPM developers guide?
  4. Is there access to REST API documentation, self documenting url maybe; similar to what swagger does? or is everything WSDL/XSD, based?

Thanks for any insight.  

 

John

 

File attachments

Like

2 comments

You can find the CRUD requests example in the atteched file. The only two things that the manual doesn't cover are CSRF token (you will receive it in the login request response and you will need to add it to all of the next requests). Please check how I add the sessionid key. You need to add the CSRF id in the same way. Besides, you can avoid using the sessionid cookie if you use the forceusesession key in the header of all of the requests.

odatawebhttprequestsupd.rar

ForceUseSession: true

 

One more thing. Please note that you need to add the CSRD key both into the header of all of the requests and to the cookie of all of the requests.

https://academy.bpmonline.com/documents/technic-sdk/7-10/protection-csr…

 

Show all comments

Hi,

I am looking for solution how to fetch by API contacts list sorted by ModifiedOn field in DESC order. I try to do such request:
POST https://010107-crm-bundle.bpmonline.com/0/dataservice/json/reply/SelectQ...

{
    "RootSchemaName":"Contact",
    "OperationType":"0",
    "Columns":{
        "Items":{
            "Name":{
                "OrderDirection":"DESC",
                "OrderPosition":"ModifiedOn",
            }
        }
    },
    "AllColumns":true
}

But sort seems not to be applied. Thanks in advance for any help here.
Best,
Lukas

File attachments

Like

1 comments

You need to use OData.

https://academy.bpmonline.com/documents/technic-sdk/7-10/working-bpmonl…

The request URL will look like 

string requestUri = serverUri + "ContactCollection?$orderby=Name";

Please note that it's not ok to select all of the contacts via API. If you have a lot of contacts, the request will take huge amount of time. I recommend to use a filtration and select only the data that you need.

string requestUri = serverUri + "ContactCollection?$filter = Id eq guid'" + contactId + "'";
Show all comments