Discussions
Join data via prod report & design element API's
over 1 year ago by Randi
I currently grab production report data from the
https://wyyerd.api.vitruvi.cc/api/v1/production/production_reports_query
API that I store in our data warehouse.
I am looking at some new production reports which have custom fields which I am planning to pull
in for reporting via the design elements for that category name in the
https://wyyerd.api.vitruvi.cc/api/v1/engineering/design_elements_query
API.
My question is how do I join the data from the Design Element fields to
the Prod Report data? I am not seeing anything too obvious and not sure if I am not seeing the field or if I am missing a middle object or piece of data that is needed to connect the two.
Any help is much appreciated - Thanks!