Community Tip - Did you get an answer that solved your problem? Please mark it as an Accepted Solution so others with the same problem can find the answer easily. X
How can i create data table(s) with its data shape through service scripting?
Solved! Go to Solution.
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
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
how to set the data shape field as the primary key through scripting?
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
Can you please mark it as accepted solution so that it can help other people as well !!
Thanks ,
Mukul Narang