How to find primary key(s) for an F&O entity?

(2) Share

Report

Posted on by HerrimanCoder

Normally I can figure out the (sometimes composite) primary key for an F&O entity, but so far I have had no luck finding the key for any of these entities:

ItemSpecificBillOfMaterialsHeaders

ItemSpecificBillOfMaterialsHeadersV2

ItemSpecificBillOfMaterialsHeadersV3

A sample record looks like this:

{
"dataAreaId":"xyz",
"BOMId":"BOM_00000001",
"ManufacturedItemNumber":"SM-HC9578-002A",
"ProductionSiteId":"01",
"ProductColorId":"",
"ProductConfigurationId":"",
"ProductSizeId":"",
"ProductStyleId":"",
"BOMName":"HC9578-002A",
"IsActive":"Yes",
"ApproverPersonnelNumber":"000013",
"IsApproved":"Yes",
"EngChgEngineeringBomReference":"",
"EngChgEngineeringVersion":""
}

Odata URL for above record:

/data/ItemSpecificBillOfMaterialsHeaders?$top=1

For simple GET queries I can always use $filter to get what I need; but in this case I need to do a PATCH update, and thus I need the exact primary key.

I queried the metadata thusly:

/data/$metadata

...and that brought a torrent of json data. Yes, I did find all 3 entities mentioned above, but the info it's giving me is certainly not the primary key(s). For example:

Those 2 properties SiteId and dataAreadId are the same in most records--not even close to unique.

So I have been using the trial-and-error method, such as:

/data/ItemSpecificBillOfMaterialsHeaders(dataAreaId='hoft',BOMId='HOFT-006037',ManufacturedItemNumber='344-25SW')
/data/ItemSpecificBillOfMaterialsHeaders(BOMId='HOFT-006037')
/data/ItemSpecificBillOfMaterialsHeaders(BOMId='HOFT-006037',ManufacturedItemNumber='344-25SW')

In all cases I get back this error:

<Error>

<Message>No HTTP resource was found that matches the request URI 'hfcorp-uat.sandbox.operations.dynamics.com/.../ItemSpecificBillOfMaterialsHeadersV3(dataAreaId='hoft',BOMId='HOFT-006037',ManufacturedItemNumber='344-25SW')'. No route data was found for this request.</Message>

</Error>

There must be a way in F&O to look up the primary key of an entity so that a PATCH request can be done against it. How is it done?

I have the same question (0)

All responses (6)

Answers (1)

Martin Dráb 236,025 Most Valuable Professional on at

Like (0)

Report

How to find primary key(s) for an F&O entity?

Actually, OData already supports it. If you download OData metadata ([your F&O URL]/data/$metadata) and locate the entity, you'll find the key definition there:

This is normally used by tools, such as code generators, but you can look there too.

1 people found this reply helpful.

Was this reply helpful? Yes No
PK-30061407-0 3 on at

Like (0)

Report

How to find primary key(s) for an F&O entity?

I have a similar problem like @HerrimanCoder. Did you get this to work?

Was this reply helpful? Yes No
HerrimanCoder 62 on at

Like (0)

Report

RE: How to find primary key(s) for an F&O entity?

Thank you - when I added dataAreaId, it worked. In case anyone from MS is watching this, there really should be a simply way, in odata, to get back the PK fields for any given entity. Would save so much trouble.

Was this reply helpful? Yes No
Verified answer

Alex VN 1,994 on at

Like (0)

Report

RE: How to find primary key(s) for an F&O entity?

Hi,

It seems like the entity you are used is a legal entity specific so you might need to include dataAreaID key into the key list as well:

dataAreaId='usmf')

Note the lower case "d" in "dataAreaId".

Regards,

Anh Ong

Was this reply helpful? Yes No
HerrimanCoder 62 on at

Like (1)

Report

RE: How to find primary key(s) for an F&O entity?

What am I doing wrong with this URL, then:

/data/ItemSpecificBillOfMaterialsHeadersV2(BOMId='HOFT-006037',ManufacturedItemNumber='344-25SW',ProductionSiteId='01',ProductColorId='',ProductConfigurationId='000448',ProductSizeId='',ProductStyleId='',ProductVersionId='')

Error: No HTTP resource was found that matches the request URI...no route data was found for this request.

This URL is the basis for my URL above:

/data/ItemSpecificBillOfMaterialsHeadersV2?$filter=BOMId%20eq%20%27HOFT-006037%27

And this is the JSON returned from that URL (with $filter in it):

{

"dataAreaId":"hoft",

"BOMId":"HOFT-006037",

"ManufacturedItemNumber":"344-25SW",

"ProductionSiteId":"01",

"ProductColorId":"",

"ProductConfigurationId":"000448",

"ProductSizeId":"",

"ProductStyleId":"",

"ProductVersionId":"",

"BOMName":"344-25SW",

"IsActive":"Yes",

"ApproverPersonnelNumber":"000013",

"IsApproved":"Yes"

}

Was this reply helpful? Yes No
Suggested answer

Sukrut Parab 71,699 Moderator on at

Like (0)

Report

RE: How to find primary key(s) for an F&O entity?

Did you check entity in visual studio ? Key is defined at the entity level.

Was this reply helpful? Yes No