search

jasonrollins / shareplum

Pythonic SharePoint
MIT License
179 stars 96 forks source link

accessing forms attached to an item in a list #126

Open wim opened 3 years ago

wim commented 3 years ago

Hi,

I am using shareplum to retreive data stored in various lists in a sharepoint site. This works very well for data that is directly stored in the fields of an item. However, some of the data is stored in fields inside a form. Through the web browser, the form is accessed by clicking the field value. It shows a pop-up with all values. The first screenshot below shows the fields for a single item. The second screenshot shows the data stored in the form attached to this item. image

image

Below is the output of GetListItems. The iD field value can be used to display the popup for the item in the sharepoint site: shpgenerator/Lists/Prototypeschepen/DispForm.aspx?ID=3 [{'Bijlagen': '0', 'Titel': 'Pauline', 'VBTYPE': '1;#Autoschip', 'Eigenschappenverzameling': '3;#', 'Goedkeuringsstatus': '0', 'Niveau': '1', 'Id': '3', 'Unieke id': '3;#{455EEA51-4079-416F-9583-D2DE1F03C132}', 'owshiddenversion': '1', 'Itemtype': '3;#0', 'Gemaakt': datetime.datetime(2012, 3, 27, 8, 30, 24), 'Naam': '3;#3.000', 'Masker voor effectieve machtigingen': '0x1b03c4312ef', 'Gewijzigd': datetime.datetime(2012, 3, 27, 8, 30, 24), 'Pad van URL': '3;#shpgenerator/Lists/Prototypeschepen/3.000'}]

Is it possible to access the data in these forms using shareplum?

Kind regards,

Wim

jasonrollins commented 3 years ago

I don't explicitly parse forms. You can use debug=True to get the full returned response to see if the data is present. If so, you could email the response to me and I can add in some parsing for you.

On Mon, Sep 28, 2020 at 7:20 AM wim notifications@github.com wrote:

Hi,

I am using shareplum to retreive data stored in various lists in a sharepoint site. This works very well for data that is directly stored in the fields of an item. However, some of the data is stored in fields inside a form. Through the web browser, the form is accessed by clicking the field value. It shows a pop-up with all values. The first screenshot below shows the fields for a single item. The second screenshot shows the data stored in the form attached to this item. [image: image] https://user-images.githubusercontent.com/39810/94430211-d3ca4180-0193-11eb-94a3-a3a2194a023b.png

[image: image] https://user-images.githubusercontent.com/39810/94430254-e2185d80-0193-11eb-935c-ca3e6d282561.png

Below is the output of GetListItems. The iD field value can be used to display the popup for the item in the sharepoint site: shpgenerator/Lists/Prototypeschepen/DispForm.aspx?ID=3 [{'Bijlagen': '0', 'Titel': 'Pauline', 'VBTYPE': '1;#Autoschip', 'Eigenschappenverzameling': '3;#', 'Goedkeuringsstatus': '0', 'Niveau': '1', 'Id': '3', 'Unieke id': '3;#{455EEA51-4079-416F-9583-D2DE1F03C132}', 'owshiddenversion': '1', 'Itemtype': '3;#0', 'Gemaakt': datetime.datetime(2012, 3, 27, 8, 30, 24), 'Naam': '3;#3.000', 'Masker voor effectieve machtigingen': '0x1b03c4312ef', 'Gewijzigd': datetime.datetime(2012, 3, 27, 8, 30, 24), 'Pad van URL': '3;#shpgenerator/Lists/Prototypeschepen/3.000'}]

Is it possible to access the data in these forms using shareplum?

Kind regards,

Wim

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/jasonrollins/shareplum/issues/126, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAOVTVXKLW637LTU5CLZ5O3SIB5RFANCNFSM4R4N6PQA .