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:
Cybersecurity
DevOps Cloud
IT Operations Cloud
If an answer to your question is correct, click on "Verify Answer" under the "More" button. The answer will now appear with a checkmark. Please be sure to always mark answers that resolve your issue as verified. Your fellow Community members will appreciate it! Learn more
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:
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.
I do not have the right explanation for this because I did not start any investigations. But what happens if shared items do not exist anymore? Ie files or folders have been deleted ...
Something like this: Knowledge Document: ERROR: update or delete on table "ss_forums" violates foreign key
Use "Verified Answers" if your problem/issue has been solved!