topic How to get via API all File Properties and their Values for all Files from the selected Assembly File? in Vault Customization Forum

How to get via API all File Properties and their Values for all Files from the selected Assembly File?

petr_cizekTGR8C — Fri, 13 Oct 2023 10:03:38 GMT

Hi, we are building an extension to Vault Professional 2024 Client to allow the user to transfer data from Vault to ERP system via the REST API. Currently the C# code is written to work with Vault Files and their Properties, we could possibly change the approach to work with Vault Items if recommended.

Our target would be to get via Vault API all File Properties and their Values for all Files from the selected Assembly File and later to work with them locally (verification, Assembly creation, Child-part creation, …) in order to minimize the number of requests to the Vault server via the API.

Our today solution works when selected single Part. We are using the PropertyManager.GetPropertyValue to get each File Property Value. When we use the same function on the Assembly which has the same part as the child-part, we could not receive the Category Name, Status , ...

Re: How to get via API all File Properties and their Values for all Files from the selected Assembly File?

Nick_Hall — Wed, 18 Oct 2023 02:42:32 GMT

Hi Petr

You can use PropertyService.GetPropertiesByEntityIds to return all the properties for all of the files (or items)

PropInst[] fileProperties = propSvc.GetPropertiesByEntityIds("FILE", new long[] { file1.Id, file2.Id, ... fileN.Id});

Hope that helps

Nick

Re: How to get via API all File Properties and their Values for all Files from the selected Assembly File?

petr_cizekTGR8C — Thu, 19 Oct 2023 23:16:53 GMT

Hi Nick, thanks for your reply. Could you please advice as well the best way to get the list of all child-files from the "assembly" file? I found this: GetItemFileAssociationsByItemIds but is not this function only for the Items? Because we work with Files in IExplorer... Thanks Petr

Re: How to get via API all File Properties and their Values for all Files from the selected Assembly File?

Markus.Koechl — Fri, 20 Oct 2023 05:37:08 GMT

There are two options to get related files: retrieve all IDs using GetFileAssociationLitesByIds or retrieve all file objects of these using GetFileAssociationsByIds. Sample code is available here: iLogic-Vault/iLogic-Vault-QuickstartLibrary/iLogic-Vault QuickstartLibrary.cs at 2023.3 · koechlm/iLogic-Vault (github.com).

Re: How to get via API all File Properties and their Values for all Files from the selected Assembly File?

Nick_Hall — Mon, 23 Oct 2023 19:26:58 GMT

Thanks @Markus.Koechl for saving me the job of replying

Nick

Re: How to get via API all File Properties and their Values for all Files from the selected Assembly File?

petr_cizekTGR8C — Fri, 27 Oct 2023 13:05:20 GMT

Hi @Nick_Hall & @Markus.Koechl, thanks for your feedback. As we go further, we face another issue...

Issue: Different Properties received for single selected file versus same file as component in Assembly

When we select single File (240189.ipt) in Vault, we get correct File properties:

Vault:

Code to get Properties if selected PART:

PropInfoArray:

In this case, the Part Number (PropDefId = 26) is 240189 which is OK.

If I select Assembly, which has this File 240189 as a component, we get wrong data…:

Vault selection:

Code to get the ChildFiles for the Assembly:

Received bom object:

bom CompArray:

BOM InstArray:

The code to check the Assembly is calling the same function isValidProperties… but the received data for the Child Part are different:

PropInfoArray:

It is mainly the Part Number and Category Name we have trouble with… but probably not limited to these.

It seems we are receiving different BOM InstanceId or XRefId (1880778 versus 1850257), but how to get the same Instance from the Assembly file…?

Are you able to help? Thanks

Re: How to get via API all File Properties and their Values for all Files from the selected Assembly File?

Nick_Hall — Mon, 30 Oct 2023 04:47:06 GMT

Hi Petr

Without having access to your Vault I can't be 100% certain about this, but I think that your assembly is referencing an older version of 240189.ipt

There are loads of ways this could happen, so it's quite plausible/likely

If you want to get the latest version, you can use GetLatestFilesByMasterIds or GetLatestFilesByIds

If I've understood correctly, you want to pass an array of CompArray.XRefId to GetLatestFilesByIds, which will give you the latest version of all the BOM Components

It will get a bit messy handling the referenced and latest components, but you should be able to work it out

But it's worth looking into why this is happening, which you can do by cross-checking the version numbers in Vault, and working back from there. It may be that you need to make changes to your workflows and/or lifecycles to ensure the data in Vault & the data in your ERP system match

Hope that helps

Nick