Solved: How-to create Service Request Note in Service Requ...

Jacques-Antoine · ‎09-23-2015

Hello dear C4C community,

I am currently developing a portal in HCP connecting our C4C demo system with the Portal.

I succeeded in creating tickets (Service Requests) from my UI5 application in the portal.

However, I am not succeeding in creating a Note (Service Request Note) in the Service request.

I just cannot find how to use the Navigation Property from the metadata of the OData service.

For the ServiceRequestCollection we have the following code as the Navigation property to Service Request Note in the $metadata.


<NavigationProperty Name="ServiceRequestNote" Relationship="c4c.ServiceRequest_ServiceRequestNote" FromRole="ServiceRequest" ToRole="ServiceRequestNote"/>

I tried to expand my OData model like :


var oModel = viewElement.getModel();
        var oServiceRequest = this.createEntryObject();
        
        var params = {}; 
        params.success = this.createTicketSuccess; 
        params.error = this.createTicketError;
        
        oModel.create("/ServiceRequestCollection?$expand=ServiceRequestNote", oServiceRequest, params);

And this is how I assign values in my createEntryObject() function:


var oEntry = {};
oEntry.Description = name; //OK
oEntry.CustomerID  = "1000077"; //OK
oEntry.Priority = priority.toString(); //OK
oEntry.ReportedOn = reportedon.toString()+"T12:00:00Z"; //OK
oEntry.ServiceRequestNote = {}; //DO NOT WORK
oEntry.ServiceRequestNote.Text = "TestJAO"; //DO NOT WORK

However, when I do that I get this error message:

2015-09-23 15:04:33 [index.html] The following problem occurred: HTTP request failed400,Bad Request,<?xml version="1.0" encoding="utf-8"?><error xmlns="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata"><code>00145E5B1CC71EE0B2834BC2E9BE0C91</code><message xml:lang="en">The Data Services Request contains SystemQueryOptions that are not allowed for this Request Type</message></error>

It is the closest I came to create a Note in a Service Request.

I am lost now as I am not a pro developer in JS and UI5.

Any help on this matter would be greatly appreciated.

Thank you for your attention.

Best regards.

Jacques-Antoine Ollier.

Former Member · ‎09-23-2015

To answer your question, you need to understand the underlying business object first so you know what to do in the API to manipulate the data in the business object.

The Service Request is a "complex" business object.

It has:

1. Header (root)

2. TimePoints 1:N to the root (node that stores all of the various time stamps for SLA and during the lifecycle of the ticket)

3. Parties 1:N to the root (node the stores all of the different "parties" attached to the ticket such as ship-to, bill-to, seller, customer, processor, service org, etc...)

4. ServiceReferenceObjects 1:N to the root (node that stores the "products" attached to the ticket like ibase, ipoint, registered product, product. Tip: on the UI we show the "main" instances of these products, but the model supports N instances -> more than one ibase, ipoint, registered product, product)

5. Items 1:N to the root (node that stores the line items of the ticket)

6. TextCollection 1:N to the root (node that stores the notes of the ticket)

7. AttachmentFolder 1:N to the root (node that stores the attachments of the ticket)

8. BusinessTransactionReference 1:N to the root (node that stores references to other C4C transactions such as emails, tasks, social media messages, SMS messages, chat messages, appointments, visits, surveys, tickets, leads, opptys, contracts)

Screen shot below of the details of the object in the SDK "Repository Explorer". This is available when you login SDK into your tenant you will have access to the "PSM" (public solution model) which is what we publish to partners and customers to consume our objects via API and SDK. The Repository Explorer will details about the object, datatypes that you can access via the oDATA explorer.

So to create notes, at a high level, you will need to find the oDATA structure that maps to the TextCollection node of the Service Request. In this structure, you will need to create an instance of the text collection, set the languagecode, typecode, and text. Since you will create the textcollection is part of the servicerequest, it will know that when you create the textcollection it will automatically link it with the servicerequest. If you need details of the code value you need to default/set for the languagecode/textcode then use the repository explorer to find the datatype which give you a complete list of supported code list values.

carlos_hidalgo · ‎01-21-2016

Hi Rei Kasai .

Can you please let me know if is it possible to read the Service Request Change Log using SDK ?. I cannot see a node with the log data inside the ServiceRequest BO.

Thanks in advance for your help!.

former_member201939 · ‎09-23-2015

Hi:

You can refer to the sample payload for Update Tickets section https://github.com/venkyvb/c4c-api/blob/master/sections/serviceticket.md. Here you ignore the $batch payload part but just use the payload under POST ServiceRequestTextCollectionCollection.

Best regards

Venki

How-to create Service Request Note in Service Request from OData service

Accepted Solutions (1)

Accepted Solutions (1)

Answers (2)

Answers (2)

Re: Delete sales area data from BP

C4C-Outlook Server side integration

Re: How can i retrieve rownumber using flexible se...

Creation of an Excel Sheet and attaching it automa...

App ID F4920 Create Sales Orders - Automatic Extra...

	oEntry.TextCollection = {};
	oEntry.TextCollection.Text = "TestJAO";
	oEntry.TextCollection.TypeCode = "10007";