Create New Record in MDM (Product Hierarchy Table) Using MDM API Java

[Former Member]

Hello all,

I have a requirement to create a record in MDM main table. Now one field of the main table is a Hierarchy. Can you give me code for MDM Java API for doing the same?

Regards,

Yogesh Bhatia

[Former Member]

Got the solution

[Former Member]

public void InsertTreeData( )

{

//@@begin InsertTreeData()

try{

MdmValue mdmValue = null;

RepositorySchema schema = null;

schema = wdContext.currentContextElement().getVa_ReposSchema();

TableId tableId = schema.getTable("Variety").getId();

Record mdmRecord = RecordFactory.createEmptyRecord(tableId);

RecordId lookUpId = new RecordId("R4");

wdComponentAPI.getMessageManager().reportWarning("Data is entered");

mdmValue = new LookupValue(lookUpId);

//FieldProperties fp = schema.getTableSchema(tableId).getField("New_Code25");

//FieldId id = fp.getId();

FieldId id = schema.getFieldId("Variety","Variety_Product_Hierarchy");

mdmRecord.setFieldValue(id,mdmValue);

CreateRecordCommand createRecordCommand =

new CreateRecordCommand(wdContext.currentContextElement().getVa_ConnectionStr());

createRecordCommand.setSession(wdContext.currentContextElement().getVa_SessionId());

createRecordCommand.setRecord(mdmRecord);

createRecordCommand.execute();

}catch(Exception e)

{

wdComponentAPI.getMessageManager().reportWarning("Insert Tree Data"+e.toString());

}

//@@end

}

[Former Member]

Thanks Yogesh for your code, it helps.