Skip to main content
M
muzzammil1-Visitor
1-Visitor
March 6, 2019
Solved

Data table creation through service scripting

  • March 6, 2019
  • 1 reply
  • 2113 views

How can i create data table(s) with its data shape through service scripting?

Best answer by mnarang

The DataShape which you are passing in the above shared code can also be created through script having primary key

 

var result1 = { dataShape: { fieldDefinitions : {abc: {name: "abc", aspects: {isPrimaryKey: true}, description: "", baseType: "STRING", ordinal: 1}} }, rows: [] };


var params = {
name: "DSwithPK" /* STRING */,
description: undefined /* STRING */,
fields: result1 /* INFOTABLE */,
tags: undefined /* TAGS */
};

// no return
Resources["EntityServices"].CreateDataShape(params);

 

 

Hope it helps

Thanks ,

Mukul Narang 

1 reply

M
mnarang5-Regular Member
5-Regular Member
March 6, 2019

I have done in this way :

 


var params = {
name: "MyTestTable1" /* STRING */,
description: undefined /* STRING */,
thingTemplateName: "DataTable" /* THINGTEMPLATENAME */,
tags: undefined /* TAGS */
};

// no return
Resources["EntityServices"].CreateThing(params);
Things["MyTestTable1"].SetDataShape({
name: "DataShapeWithBoolean" /* DATASHAPENAME */
});
Things["MyTestTable1"].EnableThing();
Things["MyTestTable1"].RestartThing();

 

Hope it helps .

 

Thanks ,

Mukul Narang 

M
muzzammil1-VisitorAuthor
1-Visitor
March 7, 2019

how to set the data shape field as the primary key through scripting?

M
mnarang5-Regular MemberAnswer
5-Regular Member
March 7, 2019

The DataShape which you are passing in the above shared code can also be created through script having primary key

 

var result1 = { dataShape: { fieldDefinitions : {abc: {name: "abc", aspects: {isPrimaryKey: true}, description: "", baseType: "STRING", ordinal: 1}} }, rows: [] };


var params = {
name: "DSwithPK" /* STRING */,
description: undefined /* STRING */,
fields: result1 /* INFOTABLE */,
tags: undefined /* TAGS */
};

// no return
Resources["EntityServices"].CreateDataShape(params);

 

 

Hope it helps

Thanks ,

Mukul Narang 

Terms & ConditionsAccessibility statement