Skip to main content
11 events
when toggle format what by license comment
Apr 11, 2022 at 16:38 comment added ThaNoob Thanks for the very well structured answer.
Apr 11, 2022 at 16:38 vote accept ThaNoob
Apr 11, 2022 at 13:32 comment added Kris Goncalves You'll just want to pull the sub-query records out before assigning it to the dataframe (see relevant question). Updated answer to show how I did it.
Apr 11, 2022 at 13:31 history edited Kris Goncalves CC BY-SA 4.0
added 948 characters in body
Apr 11, 2022 at 6:12 comment added ThaNoob Hi Kris, it is simple_salesforce. I don't know how to share the code decently in a comment but this is what I use: pd.DataFrame(sf.query("SELECT QualifiedApiName, Label, DataType, Description, IsNillable, (SELECT IsLayoutable FROM Particles) FROM FieldDefinition WHERE EntityDefinition.Label = 'Task' ")['records']).
Apr 11, 2022 at 1:31 comment added Kris Goncalves How exactly are you executing that query that you get that result? I presume, based on the example you shared in the question it's simple salesforce (python)?
Apr 10, 2022 at 20:28 comment added ThaNoob Thanks for the elaborate reply. I see that there's no evident way to just get the fields shown in the object manager. However for me this is "close enough". As it is not exactly the same I think showing the boolean value of "IsLayoutable" next to all fields available for the tooling API is the best. However if I use your exact query string and export it to csv then I don't get just the "IsLayoutable" boolean but an orderedDict with all properties of particles. I will accept it as an answer if you could show how to only get the boolean value of "IsLayoutable"
Apr 8, 2022 at 20:30 history edited Kris Goncalves CC BY-SA 4.0
deleted 1 character in body
Apr 8, 2022 at 17:06 history edited Kris Goncalves CC BY-SA 4.0
added 7 characters in body
Apr 8, 2022 at 16:33 history edited Kris Goncalves CC BY-SA 4.0
added 430 characters in body
Apr 8, 2022 at 16:17 history answered Kris Goncalves CC BY-SA 4.0