oData | Community Creatio

13:14 Dec 19, 2018

Dear Radu,

Please see the example below. Draw your attention to the column OpportunityId syntax - Opportunity/Id

http://localhost:8006/0/ServiceModel/EntityDataService.svc/OpportunityF… = Opportunity/Id eq guid'410006e1-ca4e-4502-a9ec-e54d922d2c00'

Regards,

Anastasia

Show all comments

Question

Bulk update (MERGE) using OData

integration

sam@hq.eximb.com

08:50 Sep 21, 2018

Is it possible to perform bulk update by say utilizing both $filter and MERGE?

I need it to change a number of records with the same value but it would be nice to avoid resolving Id for each one.

Direct approach failed with an error

Query options $select, $expand, $filter, $orderby, $inlinecount, $skip, $skiptoken and $top are not supported by this request method or cannot be applied to the requested resource.

You may reproduce my call by substituting appropriate Id, actually it also should update by primary key but doesn't

url -X MERGE -H 'Content-Type: application/json;odata=verbose' -H 'Accept: application/atom+xml' -i 'http://terapp-t.hq.eximb.com/0/ServiceModel/EntityDataService.svc/Accou? eq '\''648dbb58-2aea-578d-e053-2413a8c01794'\' --data '{Name: '\''Other name'\''}'

Was my syntax incorrect or the whole idea?

1 comments

Tetiana Markova

20:01 Sep 27, 2018

Hello,

Unfortunately, one http request can contains only one CRUD operation for Odata, unless using batch.

In order to update the record by primary key, please use the following syntax:

'http://terapp-t.hq.eximb.com/0/ServiceModel/EntityDataService.svc/AccountCollection(guid'648dbb58-2aea-578d-e053-2413a8c01794')'

Show all comments

Article

Tatiana Rogova

03:12 Jul 04, 2018

package cherniak.bpmonline.com;
import java.io.OutputStream;
import java.net.*;
import javax.xml.parsers.DocumentBuilder;
import javax.xml.parsers.DocumentBuilderFactory;
import org.w3c.dom.Document;
import org.w3c.dom.Element;
import org.w3c.dom.Attr;
import javax.xml.transform.Transformer;
import javax.xml.transform.TransformerFactory;
import javax.xml.transform.dom.DOMSource;
import javax.xml.transform.stream.StreamResult;
/**
* OData insert request for bpmonline
*
*/
public class App
{
    private static final String SERVICE_URL = "http://int-                web/Amdocs_T/0/ServiceModel/EntityDataService.svc/";
    private static final String AUTH_URL = "http://int-web/Amdocs_T/ServiceModel/AuthService.svc/Login";
    private static final String DS = "http://schemas.microsoft.com/ado/2007/08/dataservices";
    private static final String DSMD = "http://schemas.microsoft.com/ado/2007/08/dataservices/metadata";
    private static final String ATOM = "http://www.w3.org/2005/Atom";
    public static void main( String[] args ) throws Exception
    {
        CookieManager msCookieManager = new CookieManager();
        CookieHandler.setDefault(msCookieManager);
        if(GetAuthCookie("Supervisor", "Supervisor")) {
            CreateBpmEntityByOdataHttpExample(msCookieManager);
        }
    }
    public static boolean GetAuthCookie(String login, String password) {
        try{
            URL urlAuth = new URL(AUTH_URL);
            HttpURLConnection connection1Auth = (HttpURLConnection) urlAuth.openConnection();
            connection1Auth.setDoOutput(true);
            connection1Auth.setRequestMethod("POST");
            connection1Auth.setRequestProperty("Content-Type","application/json");
            String authJson = String.format("{\"UserName\": \"%s\", \"UserPassword\":\"%s\"}", login, password);
            byte[] outputBytes = authJson.getBytes("UTF-8");
            OutputStream os = connection1Auth.getOutputStream();
            os.write(outputBytes);
            os.close();
            int responseCode = connection1Auth.getResponseCode();
            return responseCode == 200;
        } catch (Exception e) {
            return false;
        }
    }
    public static void CreateBpmEntityByOdataHttpExample(CookieManager manager) {
        try{
            //Create xml document
            DocumentBuilderFactory docFactory = DocumentBuilderFactory.newInstance();
            DocumentBuilder docBuilder = docFactory.newDocumentBuilder();
            Document doc = docBuilder.newDocument();
            Element entry = doc.createElement("entry");
            Attr attrAtom = doc.createAttribute("xmlns");
            attrAtom.setValue(ATOM);
            entry.setAttributeNode(attrAtom);
            doc.appendChild(entry);
 
            Element content = doc.createElement("content");
            Attr attrType = doc.createAttribute("type");
            attrType.setValue("application/xml");
            content.setAttributeNode(attrType);
            entry.appendChild(content);
 
            Element properties = doc.createElement("properties");
            Attr attrMetadata = doc.createAttribute("xmlns");
            attrMetadata.setValue(DSMD);
            properties.setAttributeNode(attrMetadata);
            content.appendChild(properties);
 
            //Set Name of Contact
            Element name = doc.createElement("Name");
            Attr attrProp = doc.createAttribute("xmlns");
            attrProp.setValue(DS);
            name.setAttributeNode(attrProp);
            name.appendChild(doc.createTextNode("Test Person"));
            properties.appendChild(name);
 
            //Set Dear of Contact
            Element dear = doc.createElement("Dear");
            Attr attrOppo = doc.createAttribute("xmlns");
            attrOppo.setValue(DS);
            dear.setAttributeNode(attrOppo);
            dear.appendChild(doc.createTextNode("Mister"));
            properties.appendChild(dear);
 
            doc.setXmlStandalone(true);
 
            //Send insert request
            URL url = new URL(SERVICE_URL + "ContactCollection/");
            HttpURLConnection connection = (HttpURLConnection) url.openConnection();
            connection.setDoOutput(true);
            connection.setRequestMethod("POST");
            connection.setRequestProperty("Accept", "application/atom+xml");
            connection.setRequestProperty("Content-Type","application/atom+xml;type=entry");
 
            //Add BPMCSRF
            for(HttpCookie cookie : manager.getCookieStore().getCookies()) {
                if(cookie.getName().equals("BPMCSRF")) {
                    connection.setRequestProperty("BPMCSRF", cookie.getValue());
                }
            }
            OutputStream os = connection.getOutputStream();
            TransformerFactory tf = TransformerFactory.newInstance();
            Transformer transformer = tf.newTransformer();
            transformer.transform(new DOMSource(doc), new StreamResult(os));
            os.close();
            int responseCode = connection.getResponseCode();
            System.out.println(responseCode);
        } catch (Exception e) {
            System.out.println(e.getMessage());
        }
    }
}

0 comments

Show all comments

Question

can you query data using ODATA and filter to records in a specific folder (either Dynamic or Static)?

folders

Brian Morgan

23:04 Jun 25, 2018

we've created folders for subset of contacts. I want to pull those contacts via ODATA. anyway to filter contacts using a specific folder?

I.e. create an ODATA filter like filter=folder eq "VIP Contacts"

1 comments

Lisa Brown

10:54 Jun 26, 2018

Dear Brian,

Instead of ContactCollection, you can use ContactInFolderCollection to retrieve the folder to which the user belongs. For example (GET ServiceModel/EntityDataService.svc/ContactCollection(guid'6f586c21-4b51-42c4-a370-deec97d28c12')/ContactInFolderCollectionByContact)

ContactFolder is the object that contains all folders in case you need to get the particular folder.

Lisa

Show all comments

Question

Connecting to BPMOnline with SSIS via odata

Allen Dsouza

22:15 Mar 09, 2018

Hello,

Is it possible to use SQLServer Integration Services to pull data from BPMOnline? I tried setting up a connection via the odata connection in SSIS but the connection fails. Screenshot below. Any suggestions to resolve this are highly appreciated. Thank you.

5 comments

Best reply

https://Supervisor:Supervisor@026218-crm-bundle.bpmonline.com/0/ServiceModel/EntityDataService.svc

23:13 Mar 12, 2018

Dear Allen,

The error "401 Unauthorized" usually indicates, that credentials you have inserted are invalid.

Please try to run the following URL in the browser, where Supervisor:Supervisor are your login and password:

If it does let you in, than check the credentials.

You can also catch the request using Telerik Fiddler application and use its parameters to set up SQLServer Integration Services connection.

Regards,

Anastasia

https://026218-crm-bundle.bpmonline.com/0/ServiceModel/EntityDataServic…

17:31 Mar 12, 2018

Hello Allen,

Please try to establish connection through EntityDataService.svc. Modify the URL in the following way:

Hope you find it helpful.

Regards,

Anastasia

Allen Dsouza

18:32 Mar 12, 2018

Thank you for the suggestion. Unfortunately I still get a very similar error as the previous one. Screenshot attached.

https://Supervisor:Supervisor@026218-crm-bundle.bpmonline.com/0/ServiceModel/EntityDataService.svc

23:13 Mar 12, 2018

Dear Allen,

The error "401 Unauthorized" usually indicates, that credentials you have inserted are invalid.

Please try to run the following URL in the browser, where Supervisor:Supervisor are your login and password:

If it does let you in, than check the credentials.

You can also catch the request using Telerik Fiddler application and use its parameters to set up SQLServer Integration Services connection.

Regards,

Anastasia

Allen Dsouza

01:36 Mar 13, 2018

I tried the Supervisor login and it did not complain about the invalid login. This time it shows a message indicating "Too many automatic redirections were attempted"

13:30 Mar 13, 2018

Dear Allen,

The issue is caused by distributed licenses. Supervisor user does not have a license, therefore, every time you try to login into system, it redirects you to the license manager page.

Please use your credentials of user "Allen Dsouza" in the connection settings. On the other hand, you can distribute licenses for the Supervisor user. In this case you will successfully connect under Supervisor credentials.

Regards,

Anastasia

Show all comments

Question

json

ODATA - JSON Format

John Adkins

17:45 Dec 01, 2017

I was wondering where I can find the JSON format or record layout for an odata record in Json format; creating a contact record for example. Can the odata service describe the format?

Thanks

2 comments

John Adkins

18:01 Dec 01, 2017

It seems the basic format is simple, I jump the gun

{

                'Name': 'Test User',

                'Dear': 'TU',

                'Email': 'Tester@TestsMarketNetServices.com',

                'Phone': '6168477992',

                'Notes': 'Testing 123'

    }

Additional question: Can you nest relationships with the same document, like activities or do they have to be created separately?

14:11 Dec 08, 2017

John Adkins,

Yes, you have to create them separately. There is not way to nest relationships.

Regards,

Anastasia

Show all comments

Question

https://URL/0/ServiceModel/EntityDataService.svc/AccountCollection(guid…

21:13 Nov 29, 2017

Hi all,

2 days ago I posted asking for odata query with relationship: https://community.bpmonline.com/questions/odata-joins

I solved this issue and I posted a solution for that.

I come back because I made working querys with 1/1 relationship but not 1/n for example the idea is to get all the contacts for a particular account:

I get the attached error.

Do i have an error with the relationship names? It's possible to do in bpm'online ?

Kind regards

File attachments

ERRORBPM.txt

3 comments

https://academy.bpmonline.com/documents/technic-sdk/7-8/working-bpmonli…

14:31 Dec 06, 2017

Dear Uriel,

You can achieve such task by referring to the contact collection, filtering the results by Account Id.

The request line should look like this:

// GET <BPMonline application address>/0/ServiceModel/EntityDataService.svc/ContactCollection?$filter=AccountId eq guid'00000000-0000-0000-0000-000000000000'

You can find more filter usage here:

Also, in case you use $expand in your requests, please, take into account, that in this case OData is limited to not more than13 objects to return (see info box).

https://msdn.microsoft.com/en-us/library/gg309461(v=crm.7).aspx#BKMK_ex…

Regards,

Anastasia

16:10 Dec 06, 2017

Anastasia, how are you?

thanks for the comment.

We need something different. The query would be from 1 to N, for example from an account bring all contacts as a collection and for each contact for example bring us all the addresses.

Thinking of an XML response we should have something like this:

<?xml version="1.0" encoding="UTF-8"?>

<Response>

<Account>

<Name>Coca Cola</Name>

<Contacts>

<Contact>

<Name>john</Name>

<Addresses>

<Address>234 street</Address>

<Address>2234 street</Address>

</Addresses>

</Contact>

<Contact>

<Name>Peter</Name>

<Addresses>

<Address>234 street</Address>

</Addresses>

</Contact>

<Contact>

<Name>Caroline</Name>

</Contact>

</Contacts>

</Account>

</Response>

thank you very much.

Kind regards

12:44 Dec 08, 2017

Uriel,

Unfortunately, possibility to expand collection is not yet implemented in the system. However, please feel free to use the above mentioned approach, as a workaround.

Regards,

Anastasia

Show all comments

Question

15:57 Nov 27, 2017

Hi All!

We need to make the following query in OData using Http request.

SQL query:

select A.FieldZ, B.FieldX

from A inner join B on A.FieldA = B.FieldA

Basically the idea is to get data between relationships por example in one request to get an account including their contacts

if it is possible?

Thank you

Regards

1 comments

17:16 Nov 27, 2017

I solved it using something like this: https://URL/0/ServiceModel/EntityDataService.svc/EntityCollection(guid'…

Show all comments

Question

Problem to try to implement OData Proxy Class

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

19:28 Jun 22, 2017

Good morning,

I'm trying to follow the sample proposed on https://academy.bpmonline.com/documents/technic-sdk/7-10/working-bpmonline-objects-over-odata-protocol-wcf-client

But getting error when try to add the Web reference using the URL, in my case http://10.150.17.28:83/0/ServiceModel/EntityDataService.svc/, it says there not web services availables on this url, what could be missing?, it happens on this bpmonline 7.6 implementation and also on a 7.10 implementation.

The proyect I created to try this is a WCF Service Library, it's ok?

Thanks in advance

7 comments

Mark Bailey

21:29 Jun 22, 2017

It's ok. Hovewer, it's not recommended to use WCF in bpm'online. It's much better to use web http requests instead. I understand that it looks like WCF is more comfortable to use because of the proxy class, but it will generate a lot of difficulties in the future.

Please check the attached file. It shows how to create an OData integration via web http requests correctly. The only thing that it missed is CSRF cookie. Please add it on your own.

odatawebhttprequestsupd.docx

Mark Bailey

21:46 Jun 22, 2017

The odatawebhttprequestsupd.docx example is written using fiddler

http://www.telerik.com/fiddler

23:37 Jun 22, 2017

Thanks Mark, I will try

19:02 Jun 23, 2017

Good morning Mark,

I did some test using your tutorial and Fiddler (very good, thanks!), but now, How can I create a WS to an external app could insert data or query data to/from bpmonline using EntityDataService.svc and AuthService.svc?

Is there another tuto to this stuff?, could you help me please?

Thanks in advance,

Best regards,

Lisa Brown

20:45 Jun 23, 2017

Dear Julio,

You can achieve your task by using the OData intagration. You may find the tutorial here - https://academy.bpmonline.com/documents/technic-sdk/7-10/odata.

Lisa