API Calculations | Community
Skip to main content
J
JonnyTh1
Level 3
June 30, 2020
Question

API Calculations

  • June 30, 2020
  • 1 reply
  • 541 views

I have been trying to turn one of my reports into an API Query string. However i have got to a sticking point as one on my columns has a WORKMINUTESDIFF calculation. Is there any way this can be calculated in an API query and the results returned? Essentially i have a filter that only returns a set amount of records, which i then need to calculate the WORKMINUTESDIFF for each and then i want to calculate the average of all WORKMINUTESDIFF that are returned.

Thanks

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

    1 reply

    Doug_Den_Hoed_AtAppStore
    Community Advisor
    Doug_Den_Hoed_AtAppStoreCommunity Advisor
    Community Advisor
    June 30, 2020

    Hi Jonathan,

    Here's a primer on how to run /report queries via the API (including aggregate functions)...but as there's no mention of special Calculated Data Expressions (such as WORKMINUTESDIFF), the latter might only available via calculated custom parameters or calculated views.

    Regards,

    Doug

    J
    JonnyTh1Author
    Level 3
    June 30, 2020

    Hi Doug

    I have read all there is to read (including that link) regarding using the report API function.

    My issue is that i read things all over the internet about being able to use the API the same as you would build a report, but this doesn't appear to be the case for what i need :(

    I don't really want to go down the road of introducing another field (as i already have extra fields to record the timestamps that i want to calculate the difference of). It wouldn't be so bad if i just wanted to perform a mathematical function, but in my case i need to use the Workfront schedule to make this calculation.

    Thanks for the reply!

    Terms & ConditionsAccessibility statement

    Loading footer...