studio | Community Creatio

Anybody used HttpClient in ScriptTask?

Venkateswarlu Malli

20:15 Dec 11, 2017

Hi All,

I was not able to use HttpClient in my code to call the Async REST call with POST method.

Can anyone let me know how to use this in my Script Task?

Thanks,

Venkat.

1 comments

Lisa Brown

18:25 Dec 27, 2017

Dear Vinkat,

I'm afraid it's not completely clear from your description what's wrong. We don't recall the cases when httpclient was used in the ScriptTask but it should work there.

Make sure the necessary namespaces are added to the usings and check it again. In case you face the same difficulties, please provide us with the detailed description of the actions you take and the results you get.

Lisa

Show all comments

What happened to the search box on the community page, its missing?

John Adkins

22:44 Dec 04, 2017

Hello,

I can't seem to find the search box on the community page. I tired both chrome and edge.

Where did it go?

https://community.bpmonline.com/

2 comments

John Adkins

18:09 Dec 05, 2017

I see the search is back

Lily Johnson

13:08 Dec 08, 2017

Dear John,

In case the issue occurs again, please send this info to the support team so that we will be able to process this request.

Best regards,

Lily

Show all comments

Development System requirements

my2k

15:19 Dec 03, 2017

Hello There,

can anyone please tell me what are system requirements in order to start developing system in house.

Thanks

1 comments

Lily Johnson

19:37 Dec 07, 2017

Hello,

The system requirements can be found on our academy: https://academy.bpmonline.com/documents/studio/7-11/client-side-system-requirements

These are server side system requirements: https://academy.bpmonline.com/documents/studio/7-11/server-side-system-requirements

Best regards,

Lily

Show all comments

Public API - Example Projects - Code

John Adkins

16:50 Nov 30, 2017

I was wondering if there are working projects of the different public integration methods out there in the community before I reinvent the wheel; besides what is in the development manual, like on GitHub or on this site. I'm looking for actual Visual Studio projects or solutions; boilerplate if you will. I'm only interested in integration, not BPM customization.

Second question, where do you find the latest Terrasoft assemblies, if you are working with the cloud version only, not on premise.

Thanks everyone.

1 comments

Eugene Podkovka

12:44 Dec 03, 2017

The project in the article by the link below is working properly. I tested it last month.

https://academy.bpmonline.com/documents/technic-sdk/7-11/working-bpmonl…

Additionally, please check how to track the integration with fiddler. This will help you a lot.

https://academy.bpmonline.com/documents/technic-sdk/7-11/executing-odat…

If you need bpm'online on-site, please email to support@bpmonline.com

Please note that you will not be able to open bpm'online solutinon in VS, build it and run. Bpm'online is not OpenSource. However, on-side installation allows attaching visual studio and debugging.

Show all comments

get hidden column value in grid

Ezequiel Rául Gómez

18:00 Nov 28, 2017

Hello everyone!

How are you? I hope you can help me!

I want to add a column with a link, to set URL of that link I need to get the value of another column hidden in the grid, How could I do this? I do not want to show the column because it takes up a lot of space. I overwrote the method addColumnLink but the line "this.get("someColumn") does not work if the column is hidden. In this case, the column hidden is "UsrRutaArchivo"

I attached images

Thanks in advance!

King regards!

Ezequiel Gomez!

1 comments

15:58 Dec 13, 2017

Dear Ezequirel,

You can call initQueryColumns function in your section schema, so to load all columns. In the function, call addAllColumns you have overridden. In this case, you will be able to access not displayed column in the grid by "this.get("Column"); Please see the example below:

initQueryColumns: function(esq) {
     this.callParent(arguments);
     this.addAllColumns(esq);
},

Hope you find it helpful.

Regards,

Anastasia

Show all comments

Uriel Nusenbaum

15:57 Nov 27, 2017

Hi All!

We need to make the following query in OData using Http request.

SQL query:

select A.FieldZ, B.FieldX

from A inner join B on A.FieldA = B.FieldA

Basically the idea is to get data between relationships por example in one request to get an account including their contacts

if it is possible?

Thank you

Regards

1 comments

Uriel Nusenbaum

17:16 Nov 27, 2017

I solved it using something like this: https://URL/0/ServiceModel/EntityDataService.svc/EntityCollection(guid'…

Show all comments

Inserting Bulk Contacts from REST API

Venkateswarlu Malli

12:26 Nov 26, 2017

Hi Experts,

Need your help on how can we insert bulk Contacts. I have written the below code. But need your suggestions to know is there any way that we can insert all the records with a single statement instead of inserting one by one inside loop? I have written this code inside "Script Task".

====================================================================

var userConnection = (UserConnection)HttpContext.Current.Session["UserConnection"];

string requestString = string.Format("https://jsonplaceholder.typicode.com/users");

var request = HttpWebRequest.Create(requestString) as HttpWebRequest;

request.Method = "GET";

request.ContentType = "application/json";

HttpWebResponse response = (HttpWebResponse)request.GetResponse();

Set("ProcessSchemaParameter2", "Response Code:"+response.StatusCode +" and Response message is:"+response.StatusDescription);

StreamReader reader = new StreamReader(response.GetResponseStream());

string jsonStr= reader.ReadToEnd();

Set("ProcessSchemaParameter1", reader.ReadToEnd());

dynamic array = JsonConvert.DeserializeObject(jsonStr);

foreach(var item in array)

{

var insert = new Insert(userConnection).Into("Contact")

.Set("Name",Column.Const((string) item.name));

insert.Execute();

}

return true;

========================================================================

Thanks,

Venkat.

2 comments

15:19 Dec 08, 2017

Dear Venkat,

Unfortunately, there is no batch query realization with C# in the system. Please proceed every Contact separately.

Regards,

Anastasia

Venkateswarlu Malli

20:22 Dec 11, 2017

Anastasia Botezat,

Thanks Anastasia

Show all comments

DateTime format in DataService

Joao Cechin

12:25 Nov 14, 2017

Hey folks,

I have been trying to create a record using the DataService as specified here: https://academy.bpmonline.com/documents/technic-sdk/7-8/dataservice-add…

I have a DateTime column in the object I am trying to add, but in the documentation there is nothing saying regarding the format with which I should send the DateTime value to the service. I tried a lot of different known formats (yyyy-MM-dd HH:mm:ss, yyyy-MM-ddTHH:mm:ss, yyyy-MM-dd HH:mm, dd/MM/yyyy HH:mm:ss, yyyy-MM-ddTHH:mm:ss, and so on) but I always get the error message from server:

{"success":false,"responseStatus":{"ErrorCode":"FormatException","Message":"Input string was not in a correct format.","Errors":[]},"rowsAffected":-1,"nextPrcElReady":false}

The json I am sending is as follows, currently using the format yyyy-MM-ddTHH:mm

{"RootSchemaName":"UsrStudents","ColumnValues":{"Items":{"UsrName":{"ExpressionType":2,"Parameter":{"DataValueType":1,"Value":"Suporte"}},"UsrEmail":{"ExpressionType":2,"Parameter":{"DataValueType":1,"Value":"suporte@vedantaonline.org"}},"UsrFederalInscriptionId":{"ExpressionType":2,"Parameter":{"DataValueType":1,"Value":null}},"UsrAddressLine1":{"ExpressionType":2,"Parameter":{"DataValueType":1,"Value":null}},"UsrAddressLine2":{"ExpressionType":2,"Parameter":{"DataValueType":1,"Value":null}},"UsrAddressCity":{"ExpressionType":2,"Parameter":{"DataValueType":1,"Value":null}},"UsrAddressCountry":{"ExpressionType":2,"Parameter":{"DataValueType":1,"Value":null}},"UsrAddressZipcode":{"ExpressionType":2,"Parameter":{"DataValueType":1,"Value":null}},"UsrPhone":{"ExpressionType":2,"Parameter":{"DataValueType":1,"Value":null}},"UsrCreationTimestamp":{"ExpressionType":2,"Parameter":{"DataValueType":7,"Value":"2016-03-11T11:01"}}}},"Filters":{"FilterType":6,"Items":{"FilterById":{"FilterType":1,"ComparisonType":3,"LeftExpression":{"ExpressionType":0,"Parameter":null,"ColumnPath":"Id"},"RightExpression":{"ExpressionType":2,"Parameter":{"DataValueType":1,"Value":"67b36b17-72ae-4bab-bdd3-eb3159f9150d"},"ColumnPath":null}}}}}

The problem happens when I try to set this field: "UsrCreationTimestamp":{"ExpressionType":2,"Parameter":{"DataValueType":7,"Value":"2016-03-11T11:01"}} which is DateTime

Best regards

Joao Cechin

2 comments

Get property value of element in Business Process from Script Task

13:36 Nov 23, 2017

Dear Joao,

Please see the example below of the DateTime format to be used:

{dataValueType: 7, value: ""2017-11-23T16:00:00.000""}

This is November, 23rd, 2017. Time 4 pm or 16:00.

Hope you find it helpful.

Regards,

Anastasia

Joao Cechin

15:53 Nov 23, 2017

Anastasia Botezat,

Thank you very much Anastasia!!! I also got it to work sending in the format:

"\\/Date(1335205592410)\\/", where the number inside represents the quantity of miliseconds from 01/01/1970 till the date you want to add to the record.

Best Regards,

João

Show all comments

Ezequiel Rául Gómez

22:21 Nov 10, 2017

Hello everyone!

I hope you can help me!

I want get the value of a property of a element of my Business Process.In this case, I read all of a employee and from my script task, I want to ask about the value of one of fields, "UsrClaveAltaTemprana". The compilation of the script task is correct but when I do the test from the employee's page and I will see ths process log it pulls the following error.

System.NullReferenceException: Object reference not set to an instance of an object.

at Terrasoft.Common.ReflectionUtilities.GetPropertyValueByPath(Object source, String propertyPath)

at Terrasoft.Core.Process.ProcessModel.Get[T](String propertyPath)

at Terrasoft.Core.Process.UsrProcess3MethodsWrapper.ScriptTask1Execute(ProcessExecutingContext context)

at Terrasoft.Core.Process.ProcessFlowElement.Execute(ProcessExecutingContext context)

I attached image

I appreciated your help!

King Regards,

Ezequiel Gómez

1 comments