Retrieving all shares via REST API

Running Filr 5.0.0.2. How do I retrieve a list of all shares via the REST API? I thought rest/admin/share_settings would do it but it is missing some. I am looking for the REST API equivalent of the following in the GUI:

Tags:

Parents
  • Hmm, maybe not the right answer for you but I prefer to get the information from the database directly.

    Perhaps I cover your request here:  On-demand session: Useful SQL statements in IM&G - examples for Vibe, Filr, SMG, Retain 


    Use "Verified Answers" if your problem/issue has been solved!

  • Thanks. Looking through that I made a quick change and came up with:

    SELECT S.sharerid as sharer, P1.title Wer,
    S.sharedentity_id as ID2, F.title as Was,
    S.recipient_id as recipient, P2.title as
    AnWen,comments, daystoexpire, enddate
    FROM public.ss_shareitem as S
    LEFT JOIN public.ss_principals as P1 ON
    S.sharerid = P1.id
    LEFT JOIN public.ss_principals as P2 ON
    S.recipient_id = P2.id
    LEFT JOIN public.ss_forums as F ON
    S.sharedentity_id = F.id
    WHERE S.sharerid = <Filr User ID>;

    Is there a reason F.title as Was would return NULL for some shares? Even if I change this to F.pathname I still see NULL. What is interesting is that the following SQL command returns NULL. Maybe the file was shared and then removed, removing it from ss_forums but the share remains in ss_shareitem?

    SELECT * FROM "public"."ss_forums" WHERE id = <Share ID returning NULL>;

    The above SELECT returns 9 shared items while the GUI shows 8 shared items for the indicated user.

Reply
  • Thanks. Looking through that I made a quick change and came up with:

    SELECT S.sharerid as sharer, P1.title Wer,
    S.sharedentity_id as ID2, F.title as Was,
    S.recipient_id as recipient, P2.title as
    AnWen,comments, daystoexpire, enddate
    FROM public.ss_shareitem as S
    LEFT JOIN public.ss_principals as P1 ON
    S.sharerid = P1.id
    LEFT JOIN public.ss_principals as P2 ON
    S.recipient_id = P2.id
    LEFT JOIN public.ss_forums as F ON
    S.sharedentity_id = F.id
    WHERE S.sharerid = <Filr User ID>;

    Is there a reason F.title as Was would return NULL for some shares? Even if I change this to F.pathname I still see NULL. What is interesting is that the following SQL command returns NULL. Maybe the file was shared and then removed, removing it from ss_forums but the share remains in ss_shareitem?

    SELECT * FROM "public"."ss_forums" WHERE id = <Share ID returning NULL>;

    The above SELECT returns 9 shared items while the GUI shows 8 shared items for the indicated user.

Children