Basic 1C Procedure

To work with 1C data source, the platform uses SOAP data transfer protocol. A basic procedure of 1C data source is a web service procedure where input parameter type is basic scalar or basic table. The basic table type is a flat table, and the basic scalar type is based on a simple 1C data type.

To develop a basic procedure, there is a table with basic 1C types and corresponding internal platform types:

Basic scalar 1C type	XML data type	Internal platform type
Number	double	double
Number	integer	text
Number	long	bigInt
Number	byte	bigInt
Date	dateTime	text
Logical value	boolean	bigInt
Row	string	text
Binary data	hexBinary	bytes
Binary data	base64	bytes

Data Transfer Features

To correctly transfer data from 1C to Foresight Mobile Platform, take into account the following:

Use flat data containing a table or an array of tables.

NOTE. To use an hierarchical structure of dependent tables, set up the web service so it returns required tables as an array within one resource.

Use standard XML-schema data types and specify each data type in the procedure according to 1C data type.
Deselect checkboxes next to parameters in the Null column and set values on adding input resource parameters. A mobile platform server checks if resource parameters structure corresponds with the obtained data from 1C to further process data and calculate the delta. If resource structures do not correspond with each other, the error message is displayed.

Example

The procedure that receives input parameters (two parameters of scalar type and two parameters of table type) and returns two tables.

Input table parameters:

"p3": [[string, string, string, Boolean, Boolean, dateTime, dateTime, byte, double, string]];
"p4": [[string, string, Boolean]].

The procedure returns two output tables:

Function SimpleTypesAndStructureNew(p1, p2, p3, p4)
   ReturnedValue = FactoryXDTO.Create(FactoryXDTO.Type("http://www.test-ws.org","SimpleTypesAndStructureNew"));
   //ReturnedValue.p1 = p1;
   //ReturnedValue.p2 = p2;
   For each PlanningPeriod From p3.PlanningPeriods Cycle
       ReturnedValue.p3.Add(PlanningPeriod);
   CycleEnd;
   For each Counterpart From p4.Counterpart Cycle
       ReturnedValue.p4.Add(Counterpart);
   CycleEnd;
   Return ReturnedValue;
FunctionEnd

The procedure takes input integer of the int type, that is the Count parameter, and returns a table with the number of rows specified in the input parameter:

Function GetPlanningPeriodsCount(Count)
   start = CurrentUniversalDateInMilliseconds();

   ReturnedValue = FactoryXDTO.Create(FactoryXDTO.Type("http://www.test-ws.org","PlanningPeriodsList"));
   XDTOElementType = FactoryXDTO.Type("http://www.test-ws.org", "PlanningPeriodsElement");

   Request = New Request;
   Request.Text =
   "SELECT FIRST 1
   | PlanningPeriods.Link,
   | PlanningPeriods.DeleteLabel,
   | PlanningPeriods.Code,
   | PlanningPeriods.Name,
   | PlanningPeriods.EvenSemecter,
   | PlanningPeriods.StartDate,
   | PlanningPeriods.EndDate,
   | PlanningPeriods.StartWeek,
   | PlanningPeriods.NumberWithPoint,
   | PlanningPeriods.Comment
   |FROM
   | Dictionary.PlanningPeriods AS PlanningPeriods";

   RequestResult = Request.Execute();
   If Not RequestResult.Empty() Then
       Sample = RequestResult.Select();
       Sample.Next();

       For Counter = 1 To Count-1 Cycle
           XDTOElement = FactoryXDTO.Create(XDTOElementType);
           XDTOElement.UID = String(Sample.Link .UniqueIdentifier());
           XDTOElement.Code = String(Counter);
           XDTOElement.Name = Sample.Name;
           XDTOElement.DeleteLabel = Sample.DeleteLabel;
           XDTOEelement.EvenSemester = Sample.EvenSemester;
           XDTOElement.StartDate = Sample.StartDate;
           XDTOElement.EndDate = Sample.EndDate;
           XDTOElement.StartWeek = Sample.StartWeek;
           XDTOElement.NumberWithPoint = Sample.NumberWithPoint;
           XDTOElement.Comment = Sample.Comment;

           ReturnedValue.PlanningPeriods.Add(XDTOElement);
       CycleEnd;

       XDTOElement = FactoryXDTO.Create(XDTOElementType);

       XDTOElement.UID = String(Sample.Link.UniqueIdentifier());
       XDTOElement.Code = String(Counter);
       XDTOElement.Name = Sample.Name;
       XDTOElement.DeleteLabel = Sample.DeleteLabel;
       XDTOElement.EvenSemester = Sample.EvenSemester;
       XDTOElement.StartDate = Sample.StartDate;
       XDTOElement.EndDate = Sample.EndDate;
       XDTOElement.StartWeek = Sample.StartWeek;
       XDTOElement.NumberWithPoint = CurrentUniversalDateInMilliseconds() - start;
       XDTOElement.Comment = Sample.Comment;

       ReturnedValue.PlanningPeriods.Add(XDTOElement);
   EndIf;
   Return ReturnedValue;
FunctionEnd