Travers N. you can modify what's imported from salesforce by setting up a new list view with exactly what you want to bring into clay, then selecting that list view as the source for your clay table! you're right that it's not a setting in clay; i should've been clearer that this is a configuration you set up in SFDC.
as for this null issue: we're literally getting back null for site values directly from salesforce. here's a sample value SFDC gave us (i changed the company name, phone, owner name, id, and owner id to protect privacy, but this data is real):
{
"columns": [
{
"fieldNameOrPath": "Name",
"value": "somecompanyname.ai"
},
{
"fieldNameOrPath": "Site",
"value": null
},
{
"fieldNameOrPath": "BillingState",
"value": "CA"
},
{
"fieldNameOrPath": "Phone",
"value": "+1 999-999-9999"
},
{
"fieldNameOrPath": "Type",
"value": "SDR Target Account"
},
{
"fieldNameOrPath": "Owner.Alias",
"value": "JDoe"
},
{
"fieldNameOrPath": "Id",
"value": "0123ABCDEFGHIJK"
},
{
"fieldNameOrPath": "CreatedDate",
"value": "Fri Sep 22 00:57:07 GMT 2023"
},
{
"fieldNameOrPath": "LastModifiedDate",
"value": "Thu Nov 23 16:37:57 GMT 2023"
},
{
"fieldNameOrPath": "SystemModstamp",
"value": "Thu Nov 23 16:37:57 GMT 2023"
},
{
"fieldNameOrPath": "Owner.Id",
"value": "9876543210ABCDDEFG"
},
{
"fieldNameOrPath": "OwnerId",
"value": "9876543210ABCDDEFG"
}
]
}so the answer for this lies somewhere in your salesforce settings—we're just reporting the data, including site, exactly as salesforce is saying it is.
i'm not a SFDC expert and your best bet for why your list view is returning null for site value / how your instance is configured would likely be their customer support. but if you want to hop on a call so we can at least give it a look together, here's my calendly! https://calendly.com/colin-parsons-clay/30-minute-chat?month=2023-12
.png){kind=logo}
