Our “robot” is processing a xls file (~35k rows/a day) and is filling up Orchestrator queue with some data from that file.
It is unable to insert string that contains single quotation character. Add queue item element crashes with an error:
Exception: UiPath.Core.Activities.OrchestratorHttpException: Some values used for input might be in an incorrect format. Please note that not all properties are compatible with older Orchestrator versions at UiPath.Core.Activities.BaseQueueActivity.ValidateResponse(NativeActivityContext context, HttpResponseMessage httpResponse, String responseContent) at UiPath.Core.Activities.AddQueueItem.ValidateResponse(NativeActivityContext context, HttpResponseMessage httpResponse, String content) at UiPath.Core.Activities.BaseQueueActivity.EndExecute(NativeActivityContext context, IAsyncResult result) at UiPath.Core.Activities.AsyncNativeActivity.BookmarkResumptionCallback(NativeActivityContext context, Bookmark bookmark, Object value) at System.Activities.Runtime.BookmarkCallbackWrapper.Invoke(NativeActivityContext context, Bookmark bookmark, Object value) at System.Activities.Runtime.BookmarkWorkItem.Execute(ActivityExecutor executor, BookmarkManager bookmarkManager)
Q1: Is inserting to Orchestrator queue SQL Injection free ? Because if one is using sql query with add param and not passing ItemInformation element directly than such error shouldn’t happen.
Q2. Is there any workaround for that? Is it possible to insert a string with a single quote into orchestrator queue like i.e. “John O’Brian”?
Q3: What is a best approach to handle recovery of add queue item? Is it possible to get information of the last element inserted into Orchestartor queue?
Get transaction item always gets elements as FIFO but I couldn’t find any details in documentation to confirm it is guaranteed and how to get item as LIFO. Can anyone please provide any detailed information about that?
Q4: It is possible to create custom activities. Is there any documentation, article ,code or anything about how to make a custom activity using context of configured orchestrator? I’d like to create my own activity to get info of last inserted queue element without consuming it.