RichardD

Using data::entityBrowseRecords2 I am not getting any matches when using "Contact" as the entity type. What is the entity name for 'Co-worker' please? Should I be targeting com.hornbill.servicemanager rather than com.hornbill.core ? If so, can our local admin give the account/token I am using permission as my request fails when not target 'core'? Using the Service Manager front end, I only find users when searching against "Co-worker" and not "Contact".

How would you add two searchFilter elements please? column: h_email_1 value: foo@bar.com matchType: exact and column: h_contact_status value: 0 matchType: exact I have seen some examples for other methods where a param like searchFilter is passed an array of objects with multiple elements as a JSON string but haven't managed to get that to work here. e.g. mc.addParam("searchFilter", "[ { \"column\": \"h_email_1\", \"value\": \"foo@bar.com\", \"column\": \"h_contact_status\": \"0\" }]");

column_name should just be column column_value should just be value Still not quite there but feel like I'm getting close.

Working my way through search results and found the thread linked below which mentions 'Contact' and entityBrowseRecords2. Attempting to format the query using xmlmc.AddParam() xmlmc.AddParam("application", "com.hornbill.core"); xmlmc.AddParam("entity", "Contact"); xmlmc.AddParam("searchFilter", "[ { \"column_name\": \"h_email_1\"" + ", \"column_value\": \"foo@bar.com\"" + ", \"matchType\": \"Exact\" }" + ",{ \"column_name\": \"h_contact_status\"" + ", \"column_value\": \"0\"" + ", \"matchType\": \"Exact\" }]"); xmlmc.AddParam("maxResults", 5); xmlmc.Invoke("data", "entityBrowseRecords2");

@Victor Where may I find a list of the entity types please? Getting 'The specified primary entity [Contact] was not found' on the various values I have tried.

They are not signed in to Service Manager, they are accessing an internally hosted web application, within which we include a content section that displays their open Service Manager calls.

Thanks @Steve Giller We've done it in the past with getCustomerRequests but in this instance I need to retrieve the open calls for the customer based on their email address rather than the customer ID. I will take a look at selfserviceGetRequests though. https://api.hornbill.com/apps/com.hornbill.servicemanager/Requests?op=selfserviceGetRequests

What is the entity name for a user/customer please? Or perhaps the simpler question would be, which entity should I be specifying for the entityGetBrowseMetaData request please? Name Type Attributes Description application appNameType optional Specify the name of the application this operation relates to. If not specified then "system" is assumed. entity simpleIdType required once The name of the entity you want to query. I wasn't having any luck trying to invoke https://api.hornbill.com/data/?op=entityGetBrowseMetaData to browse a list.

Thank you.

@Victor Thank you. We may make a single request, using the email address as a filter term, and the response would include both the list of open calls and the customer ID? Or, we should make a request to return the customer ID based on email address filter and then a separate request to return the open calls with the customer ID as the filter?

Yes, filtering by customer email address sounds promising. Thank you. The call status we would like to return are: status.open, status.new, status.onHold

No worries. We are using getCustomerRequests to display the users open calls in a widget on an self-service portal. The widget shows the IN/SR number, the summary and a deep link to view the call. The portal application is moving to a new platform and that platform unfortunately does not hold the unique identifier we used for the customerId in Service Manager. Is there by chance a way to call getCustomerRequests using the user's email address instead of the customerId?

Thank you. I wish to get the open calls for a user using getCustomerRequests but I do not have the customerId value. Was hoping the customerId would be returned by getUserDetailsFromEmail

For /query/getUserDetailsFromEmail What syntax should be used for specifying the email address please? Documentation shows: queryParams Name Type Attributes Description emailAddress xs:string required once Email Address to search against Tried the following (as JSON object syntax is used for various other methods) but unfortunately this doesn't seem to work: queryParams = [ { "emailAddress": "foo@bar.com" } ] Thanks in advance of your kind response.