How to obtain sheet "created by" in Bridge for a child workflow

Cory_OWA

How can I use Bridge API Call OR Get Sheet OR another element to obtain the "Created By" metadata for use in a workflow?

I see createdBy in the sheets summary in the SDK:
sheetSummary - fields

But I don't see it in the output of past runs of either the API Call or the Get Sheet element in Bridge. I see createdDate but not createdBy.

jmyzk_cloudsmart_jp

Hi @Cory_OWA

You must set include=["ownerInfo"] as stated in the API document.

https://smartsheet.redoc.ly/tag/sheets#operation/getSheet

include	string A comma-separated list of optional elements to include in the response:

• ownerInfo - includes the owner's email address and the owner's user Id.

In the Bridge workflow, check Owner Info in the Advanced Options.

Result (the owner info at the bottom of the image below)

Alternatively, you can make an API Call to "list sheet share" and then "get user" to get detailed information about the owner or created by.

Data Reference for Owner User

{{states.Get Owner by API Call - List Sheet Share.call_api.make_api_call.response.data.0.email}}

jmyzk_cloudsmart_jp

Hi @Cory_OWA

You must set include=["ownerInfo"] as stated in the API document.

https://smartsheet.redoc.ly/tag/sheets#operation/getSheet

include	string A comma-separated list of optional elements to include in the response:

• ownerInfo - includes the owner's email address and the owner's user Id.

In the Bridge workflow, check Owner Info in the Advanced Options.

Result (the owner info at the bottom of the image below)

Alternatively, you can make an API Call to "list sheet share" and then "get user" to get detailed information about the owner or created by.

Data Reference for Owner User

{{states.Get Owner by API Call - List Sheet Share.call_api.make_api_call.response.data.0.email}}

Cory_OWA

https://community.smartsheet.com/discussion/comment/464818#Comment_464818

Hi @jmyzk_cloudsmart_jp - the issue I have with "ownerInfo" is that it is not the same as Created By for a datasheet.

Rather, this is the current owner.

Since I'm seeking the true "Created By" for a sheet or every/any sheet, you're saying that, after Get Sheet, call the API on the sheet with list sheet share and then process that data for attribute? I have not used List Sheet Share yet but I will look into this. Thanks!

jmyzk_cloudsmart_jp

Hi @Cory_OWA

If you can access the Event API, you can find out who created the sheet.

https://smartsheet.redoc.ly/tag/eventsDescription

{
  'eventId': '2.1.rOduPsAsXfAFIvBeh8dc8K1H9nVk4aRya1ejizpZPGk', 
  'objectType': 'SHEET', 
  'action': 'CREATE', 
  'objectId': 6286580859752324, 
  'eventTimestamp': '2024-12-09T06:56:40Z', 
  'userId': 5594663290726276, 
  'requestUserId': 5594663290726276, 
  'source': 'WEB_APP', 
  'additionalDetails':
   {'sheetName': 'Timeline: Display Multple Rows in a Row?', 'sourceType': 'global_template', 'sourceGlobalTemplateId': '5066554783098756'}}

NOTE: Event Reporting is a premium add-on which can be purchased for Enterprise and Advance Platinum plans only. For details on the Event Reporting add-on, please contact our Sales Team.