Using the FindSingleBusinessObjectByField Web Method

returns a single business object based on the given field or value this is a convenience web method introduced for searching for a matching record by a unique field here are some common use cases, where this web method can come in handy searching for a specific employee record by the login id field searching for a specific employee record by the primaryemail field searching for a specific standard user team record by the team field searching for a specific organizational unit record by the name field request syntax frsheatintegrationfindboresponse findsinglebusinessobjectbyfield(string sessionkey, string tenantid, string botype, string fieldname, string fieldvalue) parameters sessionkey the session key from the connect web method tenantid the tenant for which the session key is authenticated botype the type of business object to retrieve recid the unique identifier for the business object fieldname the name of the field in the business object to search against (for example, status) fieldvalue the value of the field to search for in the matching record (for example, active) return value frsheatintegrationfindboresponse object, defined as follows public class frsheatintegrationfindboresponse { public string status { get; set; } public string exceptionreason { get; set; } public webservicebusinessobject obj { get; set; } } the frsheatintegrationfindboresponse class has the following fields status provides a status value indicating whether the operation was successful a full description of the available status values is provided in the table below exceptionreason contains exception information, if the application throws an exception when running the connect web method obj the field by which the business object can be accessed, if the exact record is found via the findbusinessobject web method (that is, if the the value of the status field is success ) the following table lists the available status values and describes how to interpret them \<font color="#ffffff">status\</font>\<font color="#ffffff">explanation\</font> success successfully found the business object access the business object from the obj field error cannot find the business object the obj field is null inspect the corresponding exceptionreason field to determine why the web method failed one typical error is table not found , which occurs when the specified business object does not exist in the tenant ensure that the name of the business object is spelled properly another common error is that the specified field does not exist for the business object the error message is objecttablemap field \<fieldname> is not found in table \<business object># ensure that the field name is spelled correctly, and that it is defined for the given business object notfound the specified business object exists in the tenant, but the given recid does not match any of the existing records in the object since this is not an exceptional condition, no exception is stored in the exceptionreason field but the obj field is null ensure that the recid for the intended record exists in the tenant consider using a different web method, such as findsinglebusinessobjectbyfield multipleresults the provided search criteria returned more than one matching result because the purpose of this web method is to return a single matching business object, the obj field is null consider using the findsinglebusinessobjectbyfield web method instead example frsheatintegrationfindboresponse res = frsvc findsinglebusinessobjectbyfield(authsessionkey, tenantid, "incident", "incidentnumber", "10001"); if (res status == "success") { foreach (webservicefieldvalue f in res obj fieldvalues) { if (string compare(f name, "lastmoddatetime", true) == 0) { datetime lastmod; if (f value != null) { lastmod = (datetime)f value; console writeline("the lastmoddatetime of the record is " + lastmod tostring()); } } } }