Forum Discussion

JeffreyMoore's avatar
JeffreyMoore
Qrew Trainee
5 years ago

OneDrive and Pipelines

Hi All,

I am having trouble with sending files to OneDrive via Pipelines.

This is the URL I am sending to OneDrive:
https://xxxxxxx.quickbase.com/up/xxxxxxx(table dbid)/g/r{{a.id}}/eg/v0/{{a.file_name}}

It does not work. I can generally anticipate what the characters are after the "r". If I guess right the file will upload. Obviously I cannot manually update the pipeline between every attachment upload. I am not understanding why the API guide says that the record id (RID) comes after the "r", because sometimes the characters that come after the "r" are letters and sometimes numbers which does not correlate with the actual record id of the item in the table.
Appendix B: Managing files

Does anyone know how to fix this?

Thanks for your help.

Jeff

------------------------------
Jeffrey Moore
------------------------------
  • AustinK's avatar
    AustinK
    Qrew Commander
    If it is using letters as the RID then it is being converted to "QB32" format, a form of encoding Quick Base uses.

    Here are some examples. The formula converting the rid to QB32 format is just "QB32Encode([Fake Record ID#])".



    It might be possible to just create a formula field there and have that create your QB32 RID and just insert that instead of the original Record ID#.
    • JeffreyMoore's avatar
      JeffreyMoore
      Qrew Trainee
      Hi Austin, 

      Thank you so much for your help! That makes a lot of sense. Do you know what the code for "QB32Encode([Fake Record ID#])" would look like in Jinja by chance? (the language for pipelines)?

      Thanks again.

      Jeff

      ------------------------------
      Jeffrey Moore
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        Jeffery, a convenient cheat if you don't want to have to code with too much Jinja coding to make the field in Quick Base and refer to the Quick Base field in the Pipeline.

        ------------------------------
        Mark Shnier (YQC)
        Quick Base Solution Provider
        Your Quick Base Coach
        http://QuickBaseCoach.com
        mark.shnier@gmail.com
        ------------------------------