Forum Discussion

AmberPolston's avatar
AmberPolston
Qrew Cadet
5 years ago

Pipelines Sharepoint

I have been playing around with pipelines and now the sharepoint pipeline has been released.  Does anyone know how to create a pipeline to take a file attachment from QuickBase to a folder in SharePoint?  I can't seem to get it to work and this would really help our procurement process if it was possible.

------------------------------
Amber Polston
------------------------------

5 Replies

  • The SharePoint channel for Pipelines does not allow you to move files from one system to another. The channel is designed to allow you to integrate data from Quick Base and other 3rd party systems with information in SharePoint Lists. A SharePoint List is simply a table of data - like an excel spreadsheet or Quick Base table - with rows (Items) and columns (metadata) that is stored in SharePoint. You can use the SharePoint channel for Pipelines to trigger basic actions on Items in a List (create, update or delete), or to update data in another system when an Item is added/updated/deleted. Since SharePoint document repositories are also considered Lists, you can use the channel to trigger actions involving the metadata for these Items, but you cannot edit the contents of a file (i.e. edit a word document or spreadsheet), or move files from one system to another.

    It seems like this functionality would be valuable to you, so please consider posting your feedback in our UserVoice forum!

    ------------------------------
    Graham Leto
    ------------------------------
  • Hello @Amber Polston, did you already created UserVoice for this case?

    I am also looking for this solution to not consume 500 MB for one table to fast.

    One good quality attachment with picture ​may have 5-10 MB so 50 records and you are out for space :(



    ------------------------------
    Adam Krzyzanek
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Qrew Champion
      Adam, there is a difference between file attachment space and data space.  The table limits are 500 MB for data.  That would be about 1 million records having 50 scalar (data entry) fields per record.

      The limit for file attachment space is Realm wide and is a much higher limit.

      ------------------------------
      Mark Shnier (YQC)
      mark.shnier@gmail.com
      ------------------------------
      • AdamKrzyzanek's avatar
        AdamKrzyzanek
        Qrew Captain
        Thank you very much for letting me know. I was not using attachments field not only because of storage size but also mostly that for SharePoint it gives better accessibility and edition possibility.

        But in this case I will check with my Realm manager what is our attachment storage size.

        ------------------------------
        Adam Krzyzanek
        ------------------------------