For partners that build or integrate commercially available applications and service solutions with the Oracle Cloud Platform
For partners that provide implementation or managed services around Oracle Cloud Applications
Hi , I was reading through the ConnectPHP guide for Oracle 18A , I want to be able to delete records using this code snippet. Would I run this from the customer portal somehow? Or am I able to log into the CLI using OPC ?
Hi Mike - no, that query area in the Connect Object Explorer is just an interface for running ROQL select statements, not PHP code.
In Service Cloud, the only places to host and run PHP code and use the Connect PHP API would be:
Also, to add on to what Robert is listing here, if you go the ConnectPHP or REST API route of deleting incidents using ROQL, make sure that you specify that you are using CCOM v1.4 and also specify an application context.
Here is the reference documentation:
1. ConnectPHP
2. REST API
Hope this helps,
Raj
There are some decent examples in the REST API Guide but the GUIDE doesn't show you any working examples and assumes you know what to enter after query=
Moreover how do you get the record ID for an incident by the the LookupName for example 180614-000013
}
https://your_site_interface/services/rest/connect/version/queryResults/?query=semicolon-separated ROQL DELETE
When I tried https://interface.custhelp.com/services/rest/connect/v1.3/queryResults/?query=11635%20ROQL%20DELETE%20queries
I got a response
{ "type": "https://interface.custhelp.com/services/rest/connect/exceptions/OSC-CREST-00019", "title": "Invalid query parameter value", "status": 400, "detail": "This query is not supported: near \"11635\": syntax error", "instance": "https://interface.custhelp.com/services/rest/connect/v1.3/queryResults/?query=11635%20ROQL%20DELETE%20queries", "o:errorCode": "OSC-CREST-00019" }
Can you provide me with an example on how to delete a single incident ? Or do you have any cheatsheet of working examples ?
Thank you.
Mike,
The documentation that I posted above has examples of how to perform the DELETE operations.
With that said, looking at your request that you have posted, there are a couple of things that stand out:
https://interface.custhelp.com/services/rest/connect/v1.4/
https://interface.custhelp.com/services/rest/connect/latest/
https://interface.custhelp.com/services/rest/connect/v1.4/queryResults/?query=DELETE%20FROM%20incidents%20WHERE%20referenceNumber%20=%20'180614-000013'
As far as working examples, I have built a few wrappers for the REST API. I have examples for running DELETE requests in the terminal or in scripts using the following languages/environments:
I would modify your query first; however, should you need help with any of the wrappers feel free to ping me here and I will do my best to help you out.
Kind Regards,
Raj
Hi Mike - no, that query area in the Connect Object Explorer is just an interface for running ROQL select statements, not PHP code.
In Service Cloud, the only places to host and run PHP code and use the Connect PHP API would be: