0

How to identify the GUID of field 'Timesheet Manager', which is present in OData by name 'ResourceTimesheetManageId'? I don't want to know GUID of resource who is Timesheet Manager, I want to know GUID of this field 'Timesheet Manager'.

0

Get yourself Sharepoint Manager (or other free SharePoint browsing tool) it will allow you to browse through the properties of the site collection to the level of item/field and find the GUID.

  • Thank you Marek. How/where do i get SharePoint browsing tool. Does it work for SharePoint/Project Online also? – PallavN Jul 2 at 13:08
  • Also, is it safe to use any that kind of third party tool for data security? – PallavN Jul 2 at 13:11
  • Ok I have downloaded this one, github.com/bramdejager/spcb. Now in this, there is no specifically Timesheet Manager defined. How do I find that column. There is a column Manager Name. Is it same as Timesheet Manager? – PallavN Jul 2 at 13:52
  • Thank your Marek, I have searched throughout in this tool, but timesheet Manager is nowhere present. I have searched through solution given by Nils also below, but that also wan't much helpful. – PallavN Jul 2 at 14:41
0

I don't know of a way to get the id, or if a uid exists for that field. Traditionally, the databases for project server have not been documented, as we're supposed to use the API and not the connect directly to the draft or published database (which exist in on-prem installs). In both the reporting database (on-prem) and the rest api, UIDs are available for all custom fields, but not OOB fields.

  • Thank you. I have seen all the fields,lists, properties and whatever possible. But Timesheet Manager is present nowhere. I take that it is not possible to identify GUID of this field or it doesn't exist. – PallavN Jul 2 at 14:39
0

After having discussion with both the above users and I have tried both the solutions also, I have reached to conclusion that there is no GUID for this field 'Timesheet Manager' or it is not possible to identified, though almmost all the data is fetched using both the above tools. Anybody has some other knowledge on this, please let me know.

-1

Use PnP

Connect-PnPOnline https://my.sharepoint.com/sites/someSite
$l = Get-PnPList ListName
Get-PnPField -List $l FieldName | Select Id
  • how do I find GUID of Timesheet Manager field using this? – PallavN Jul 2 at 14:05
  • Well, you could list all fields, including Id (which is the guid of the field). The solution is essentially the same as the one above. Go have a look at the field and you'll see the id. – Nils Jul 2 at 14:08
  • I have generated all fields, but field 'Timesheet Manager' is not present anywhere – PallavN Jul 2 at 14:27

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.