I am having a really difficult time understanding how to dynamically pull this data from a web page. I will run the flow daily for each day of data.
There will always only be data for today (either 1 row or 0 rows if there is no data). The columns are dynamic and change whether or not there is data for that day. For example, here is an example of the data with ALL the columns:
FULL SIZING (all columns)
NO COLUMNS:
NO SIZING (no columns)
PARTIAL DATA (some columns):
PARTIAL SIZING (not all columns)
I am struggling with dynamically assigning the values to the correct column headers. I have tried using the full XML Path but it does not properly track the values with the proper headers.
What is the easiest way to pull the values and assign them to the headers (such as in a variable)? Each day, it could be either the full, partial, or no data, so it needs to be dynamic enough to capture that. For context, this is in a web page where I can inspect element. But I am not sure which actions to use and how to dynamically select the correct values for the sizing.