Requesting a GET method for Reserves Category Monthly Cash Flow!
Thanks as always to the dev team - Michael
1 Like
@michael.tanner makes sense. I will follow up with the team about this request.
2 Likes
hi @maikel.ruiz, has this feature been added? I’m also looking to pull Monthly Cashflow Well Reports from an econ run.
Hi Steven, we do have an end point for pulling monthly exports (namely the CSV export) projects/:projectId/scenarios/:scenarioId/econ-runs/:econRunId/monthly-exports/:id, but if you are looking for a get method to pull certain columns directly from the econ run, that is not yet implemented to my knowledge.
If an endpoint for this would be useful to your workflow, we can pull it in as a formal feature request and plan for it
Thanks for the reply! I’m able to pull the monthly exports using that end point, however, I’m looking to pull one liner info by Well Monthly Cash Flow on the csv export if possible. See image attached.
If I can’t pull this info - would the next best step be to pull the one-liner endpoint and create the Monthly Cashflow roll up myself?
this is my attempt to take the monthly well cash flows and aggregate by month
Thank you for sharing that with us, @StevenDestine , is this aggregation what you are referring to by rollup? If not can you expand on what you are attempting to do by pulling the one liner info?
Also, if desired, we could probably expand out our monthly-exports to allow for aggregate report exports as well so that one no longer needs to manually do so but can leverage CC’s native aggregation method within the econ run
I’m not 100% sure on that, I am trying to pull out the Well Monthly Cash flow instead of the aggregate monthly cash flow for now.
The reason I am pulling the one liner info is because I’m selecting Fast as the run mode when I run a scenario. Running the fast mode does not give me an option to do a csv export on the monthly tab.
Further expanding out that monthly-exports would be great, as we will begin pulling out that aggregate report info as well!
Gotcha, I think we’re on the same page now. So you want to get the monthly cashflows but since the econ run mode is fast you’re unable to export the monthly-cashflow-csv and ultimately unable to fetch the monthly cashflow using the endpoint? And you’d like an endpoint that is able to fetch columns such as cashflow from the econ run regardless of whether the monthly-export was run or not?
correct on all on all questions!
Understood, this is a valid issue with the fast run. We’ll bring this in to scope it and we should be able to give you an ETA later this week. It would also help us out if you could inform us about the urgency of the new endpoint
1 Like
Urgency is loose, it’s not a P1 by any means but having access to the new endpoint within the next few weeks would be extremely beneficial. I really appreciate your support on this.
hey, thanks for the help. Any eta on this new endpoint?
Hey @StevenDestine, Hyeok is out on vacation until tomorrow. He should be able to get you an estimate once he’s back.
1 Like
@StevenDestine Sorry about that Steven, I’m going to put it on my plate later this week and will try to get it done by the end of next week. If there are any specificities you’d like to request for parameters, you can leave it here or we can further discuss them.
sounds great Hyeok, that works well for us. No specific parameters needed at the moment, the standard ones lists in the api docs should suffice.
Hey Steven, an update on this. I’m actively working on this this week and am about halfway through it. I’m gonna list down some parameters here and let me know if you want anything else.
Required input parameter: econ_run_id
Optional parameters: columns, start_date, end_date
these parameters look good - thanks for working on this.
@StevenDestine Hey Steven, sorry one more thing before we release this out. For the formatting of the return body we have two options
{column_1: [value_1, value_2, value_3], columns_2: [value_1, value_2, value_3]}
[{column_1: value_1, column_2: value_1}, {column_1: value_2, column_2: value_2}, {column_1: value_3, column_2: value_3}]
Which one would you prefer?
option 1 - thank you.