Forum Discussion

RyanStanford1's avatar
RyanStanford1
Qrew Captain
6 years ago

API_EditRecord to Duration field

I'm working on using JavaScript to get the duration of a video, and I want to upload this duration into QB via API Call.

I can't seem to get the time formatted correctly to where the Duration field is able to read correctly once uploaded.

If I have it in full milliseconds, QB thinks the whole number is days...

Anyone know the trick for what format I need the time to be in for API calls?

------------------------------
Ryan Stanford
------------------------------
APIs and custom code
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    6 years ago
    A pure guess on my part but I suggest trying the same way you would enter it manually.  For example Quick Base understands seconds and minutes and hours.
    e.g.
    5.2 minutes
    123 seconds
    0.1 hours

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    markshnier2@gmail.com
    ------------------------------
    • RyanStanford1's avatar
      RyanStanford1
      Qrew Captain
      6 years ago
      It's looking like the best way for me to get around this is to not treat this as a number... as it doesn't know what units I'm using...

      I sent pure seconds, and let's just say it looked "creative" in it's representation.

      I can convert to "MM:SS" time textually, and then it should render appropriately.

      ------------------------------
      Ryan Stanford
      ------------------------------