a few of the columns in the API request are not properly calculated, i'm just publishing as an example/for discussion