MIDP (Excel-file) queries VAULT

[michael_m_kluttig]

Hello, we are using Excel to for our Master Information delivery plan. CDE is VAULT. It would be perfect, if I was able to query VAULT on the status of a modell or file and update the value in my MIDP. Is there another way than creating reports in certain intervals and lookup the data in Excel?

[michael_m_kluttig]

Hello, we are using Excel to for our Master Information delivery plan. CDE is VAULT. It would be perfect, if I was able to query VAULT on the status of a modell or file and update the value in my MIDP. Is there another way than creating reports in certain intervals and lookup the data in Excel?

[christian_gessner]

Hi @michael_m_kluttig, 

COOLORANGE powerJobs can subscribe/hook to a Vault file lifecycle state change, read the file metadata and populate an Excel spreadsheet with the file properties. powerJobs could also frequently run a custom Vault job that automatically performs the action you described.

Feel free to reach out by email in case you want to learn more or if you want to discuss your use case.

Thanks,

Christian

[christian_gessner]

Hi @michael_m_kluttig, 

COOLORANGE powerJobs can subscribe/hook to a Vault file lifecycle state change, read the file metadata and populate an Excel spreadsheet with the file properties. powerJobs could also frequently run a custom Vault job that automatically performs the action you described.

Feel free to reach out by email in case you want to learn more or if you want to discuss your use case.

Thanks,

Christian