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')'







 

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

Hello Allen,

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

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

Hope you find it helpful.

Regards,

Anastasia

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

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:

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

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

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"

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

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?

John Adkins,

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

Regards,

Anastasia

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:

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

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

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

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

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

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.

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

odatawebhttprequestsupd.docx

The odatawebhttprequestsupd.docx example is written using fiddler 

http://www.telerik.com/fiddler

Thanks Mark, I will try

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,

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

Thanks Lisa, I will try, what kind of proyect I must to start on Visual studio? console?, Web? the module where I must create and insert the code explained in the academy, what kind of module must I add to the proyect?

I did it and get a lot of comiplation errors, I'm using, in this case VS 2015

The sample provided in the academy assumes a lot of steps I didn't know,

Can I work with VS 2017? I understand it doesn't supports OData at this time.

Thanks in advance

Dear Julio,

You can use any type of project, but we recommend to use 'Console' one.

The errors occur because you have to insert a piece of code into the brackets. Please see screenshot below:

http://prntscr.com/fpi5dj

Regarding using VS 2017, I have clarified this issue with our platform team. There is no reasons to consider that it doesn't support Odata. 

Best regards,

Diana Adams

Dear Stefanie,

The issue is connected to the URL you are using to obtain the data. You are missing the configuration indication. Please see the modified URL below, I have added "0" before ServiceModel.

https://acuity.bpmonline.com/0/ServiceModel/EntityDataService.svc/ContactCollection?selectId,Name 

Feel free to use this URL and proceed with your work and system functionality.

Dear Alexander,

Please find more information and documentation about O'Data on the official website http://www.odata.org/ as we do not have such examples.

Regards,

Lily

Hi,

Here is an example how to create Activity and upload attachment to it:

using System;
using System.IO;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.Services.Client;
using System.Net;
using ODataProxyClient.ODataProxyClient;//Reference to EntityDataService.svc proxy

namespace ODataProxyClient
{
	class Program
	{
		//Specify your website Uri here
		private const string baseUri = "https://yoursite.bpmonline.com";
		private static Uri serverUri = new Uri(baseUri + @"/0/ServiceModel/EntityDataService.svc/");

		static void Main(string[] args)
		{
			CreateActivityWithAttachment();
		}

		static void OnSendingRequestCookie(object sender, SendingRequestEventArgs e)
		{
			Authentification.TryLogin("Supervisor", "Supervisor", baseUri);
			var req = e.Request as HttpWebRequest;
			req.CookieContainer = Authentification.AuthCookie;
			e.Request = req;
		}

		public static void CreateActivityWithAttachment()
		{
			Guid activityId = Guid.NewGuid();
			//Create application context
			var context = new BPMonline(serverUri);

			DataServiceRequestArgs _args = new DataServiceRequestArgs();
			//Define content type
			_args.ContentType = "application/octet-stream";

			//Read file from file system
			byte[] bytes = System.IO.File.ReadAllBytes(@"C:\Activity.csv");

			using (var fs = new MemoryStream(bytes))
			{
				//Create new activity. Remember to specify all required fields
				var activity = new Activity()
				{
					Id = activityId,
					Title = "Test activity with attachment",
					TypeId = new Guid("FBE0ACDC-CFC0-DF11-B00F-001D60E938C6"),
					StatusId = new Guid("384D4B84-58E6-DF11-971B-001D60E938C6"),
					AuthorId = new Guid("410006E1-CA4E-4502-A9EC-E54D922D2C00"),
					OwnerId = new Guid("410006E1-CA4E-4502-A9EC-E54D922D2C00"),
					StartDate = DateTime.Now,
					DueDate = DateTime.Now,
					ActivityCategoryId = new Guid("F51C4643-58E6-DF11-971B-001D60E938C6"),
					PriorityId = new Guid("AB96FA02-7FE6-DF11-971B-001D60E938C6")
				};
				//Create new activity attachment
				//Remember to specify filename with extension
				ActivityFile NewFile = new ActivityFile()
				{
					Id = Guid.NewGuid(),
					Name = "Activity.csv",//File name with extension
					Size = (int)fs.Length,
					TypeId = new Guid("529BC2F8-0EE0-DF11-971B-001D60E938C6"),//Attachment type - File
					Uploaded = true
				};
				//Define method for authentication
				context.SendingRequest += new EventHandler<SendingRequestEventArgs>(OnSendingRequestCookie);
				//Add created activity to collection
				context.AddToActivityCollection(activity);
				//Add new activity file to collection
				context.AddToActivityFileCollection(NewFile);
				//Link file with activity
				context.SetLink(NewFile, "Activity", activity);
				//Save changes
				DataServiceResponse responces = context.SaveChanges();
				//Write file stream to activity file
				context.SetSaveStream(NewFile, "Data", fs, true, _args);
				//Save changes
				context.SaveChanges();
			}
		}
	}
}

The same example via the HttpWebRequest

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.IO;
using System.Linq;
using System.Net;
using System.Xml;
using System.Xml.Linq; 

namespace ConsoleApplication1
{
    class Program
    {
        // String of address bpm’online OData servise.
        private const string serverUri = "https://0424747-sales-enterprise-demo.bpmonline.com/0/ServiceModel/EntityDataService.svc/";
        private const string authServiceUtri = "https://0424747-sales-enterprise-demo.bpmonline.com/ServiceModel/AuthService.svc/Login";

        // Links to XML name spaces.
        private static readonly XNamespace ds = "http://schemas.microsoft.com/ado/2007/08/dataservices";
        private static readonly XNamespace dsmd = "http://schemas.microsoft.com/ado/2007/08/dataservices/metadata";
        private static readonly XNamespace atom = "http://www.w3.org/2005/Atom";

        private static readonly Guid FileTypeId = new Guid("529BC2F8-0EE0-DF11-971B-001D60E938C6"); 

        static void Main(string[] args)
        {
            var file = ReadFile("z:/2SupportLine/chrome.png");
            var id = CreateBpmEntityByOdataHttpExample();
            TransferImage(id, "Data", file);

        }

        public static Guid CreateBpmEntityByOdataHttpExample()
        {
            Guid id = Guid.NewGuid();
            // Creating a xml message containing data on the created object.
            var content = new XElement(dsmd + "properties",
                          new XElement(ds + "ContactId", new Guid("410006e1-ca4e-4502-a9ec-e54d922d2c00")),//supervisor contact Id
                          new XElement(ds + "Id", id.ToString()),
                          new XElement(ds + "TypeId", FileTypeId.ToString()),
                          new XElement(ds + "Name", "test1.png")
                          );
            var entry = new XElement(atom + "entry",
                        new XElement(atom + "content",
                        new XAttribute("type", "application/xml"), content));
            Console.WriteLine(entry.ToString());
            // Creating a request to the service which will add a new object to the contacts collection.
            var request = (HttpWebRequest)HttpWebRequest.Create(serverUri + "ContactFileCollection/");
            request.Credentials = new NetworkCredential("Supervisor", "Supervisor");
            request.Method = "POST";
            request.Accept = "application/atom+xml";
            request.ContentType = "application/atom+xml;type=entry";
            // Recording the xml message to the request stream.
            using (var writer = XmlWriter.Create(request.GetRequestStream()))
            {
                entry.WriteTo(writer);
            }
            // Receiving a response from the service regarding the operation implementation result.
            using (WebResponse response = request.GetResponse())
            {
                if (((HttpWebResponse)response).StatusCode == HttpStatusCode.Created)
                {
                    // Processing the operation implementation result.
                }
            }
            return id;
        }

        public static void TransferImage(Guid fileRecordId, string columnName, byte[] file)
        {
            // Creating a request to the service which will add a new object to the contacts collection.
            var request = (HttpWebRequest)HttpWebRequest.Create(serverUri + "ContactFileCollection(guid'" + fileRecordId.ToString() + "')/" + columnName);
            request.Credentials = new NetworkCredential("Supervisor", "Supervisor");
            request.Method = "PUT";
            request.Accept = "application/octet-stream,application/json;odata=verbose";
            request.ContentType = "multipart/form-data;boundary=+++++";
            // Recording the xml message to the request stream.
            using (Stream requestStream = request.GetRequestStream())
            {
                requestStream.Write(file, 0, file.Length);
            }
            // Receiving a response from the service regarding the operation implementation result.
            using (WebResponse response = request.GetResponse())
            {
                if (((HttpWebResponse)response).StatusCode == HttpStatusCode.Created)
                {
                    // Processing the operation implementation result.
                }
            }
        }

        public static byte[] ReadFile(string filePath)
        {
            byte[] imageArray = System.IO.File.ReadAllBytes(filePath);
            return imageArray;
        }
    }
}

Mark Bailey,

I know this is a bit of an old post but I'm currently trying to implement your HttpWebRequest example. Do you know if this is still the correct way to implement the upload or has something changed? When I run this, I get a StatusCode of "NoContent" (not "Created") - with no error message or anything. Any help would be appreciated.

Aron Hoekstra,

There are two methods in the example 

CreateBpmEntityByOdataHttpExample 
and 
TransferImage

Which one is not working? Does the system create a new empty file?

Additionally, please check if the path to the file is correct 

var file = ReadFile("z:/2SupportLine/chrome.png");

Mark Bailey,

It is the TransferImage portion which is causing a problem. I have modified your code a bit to fit my use case but the end result is yes I get a new attachment record, but I can't click to actually download the file. I basically get a 404. Yes I have confirmed I am reading the file correctly and getting the byte array into the 'file' variable.

Aron Hoekstra,

The fact that you receive the 404 exception means that you didn't load the attachment in the "TransferImage" method.

Please try to run my code instead the one that you modified. Please check it if works without the moifications. Please sent me the code that you ran. Additionally, please catch the request that you send in the TransferImage method with fiddler and let me check it.

Mark Bailey,

I went back to your example and it worked.. So I went back to my code and realized that I hadn't assigned the TypeId field as you do in your example. I didn't know that was a required field - but apparently it is. My code is now working - thanks for your help!

Mark Bailey,

This is an old post, but I am testing your code to create attachments in 7.13. I am using your sample code as-is with the exception of changing URLs etc.

The ContactFile record is created file in the CreateBpmEnityByODataHttpExample method, however, when the TransferImage method runs I get a 405 "method not allowed" error. I've tried PATCH and MERGE instead of PUT with the same results.

Do you happen to know if this should still work in 7.13? Maybe I am missing something? 

Thanks,

Ryan

bsegers@goism.com,

Ryan Farley,

Unfortunately, there is no such possibility on current system version, Please feel free to use basic functionality for working with files. Take a look at FileServices and FileRepository schemas in the system configuration. There you can find methods for upload/download of file and use it in your development.

Regards,

Anastasia

In our implementation, it worked fine using the HttpWebRequest form, but now it is no longer working and returns the following error.

'The remote server returned an error: (400) Incorrect Request.'

UPDATE: My problem is when I try to upload a .docx or .xlsx type file, and it fails to upload, when it is a PNG or PDF it works normally.