Skip to main content
Question

OneDrive and Pipelines

  • May 14, 2020 11:18 PM UTC
  • 0 replies
  • 140 views

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
------------------------------
This topic has been closed for replies.

  • Qrew Colonel
  • May 18, 2020 6:55 PM UTC
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#.