Skip to main content
Broadcast Only

* Customer Architect Community *

Welcome! Join the community of Salesforce customer architects where success takes you to new levels. Network with peer architects, and Salesforce experts and engage them on topics that will accelerate strategies, plans, and implementations for your Enterprise. --------------------------------------- This group is maintained and moderated by Salesforce employees. The content received in this group falls under the official Forward-Looking Statement: http://investor.salesforce.com/about-us/investor/forward-looking-statements/default.aspx

Hi all,

 

We were informed from newbies (not experts) in Hubspot that for the integration between Salesforce and Hubspot following permissions are documented in Hubspot:

 

  • API Enabled
  • View Setup and Configuration
  • Modify All on any objects (accounts, campaigns, contacts, leads, or opportunities) that you would like to sync to Hubspot
  • Have the Modify Metadata permission (to view data in the Hubspot Visualforce window on Salesforce lead and/or contact records). This is only required if you want to use the Visualforce window, and sync deals to Hubspot
  • Have the Download AppExchange Packages permission

What I see as risk are the "Modify all" permissions and Modify Metadata permissions, as this includes all records created or assigned to any users bypassing the OWDs and sharing rules. I created a permission set to assign to a specific user, who will execute the integration. He said, he needs to sync accounts, contacts, leads and opportunities to Hubspot. He also needs to view data in the Hubspot Visualforce window, but I am wondering why the documentation says you need "Modify Metadata" permission for that!!!. It is too dangerous if you give such permissions to non-admins.

 

I would appreciate any guidance from experts in the Hubspot Integration with Salesforce, which permissions are really needed for the Integration. 

@Salesforce Administrators & Developers,  @* Outlook/Teams, Gmail, and Inbox *, @* Customer Architect Community *

11 answers
  1. Jan 12, 2023, 2:42 PM

    Hi @Lena Wong,

     

    You've got it exactly.  

     

    To expand on it... (and also why I suggested your Senior admin is the integration user, since they would already have the modify all permission) the actual integration between Hubspot and Salesforce requires a user who will serve as the integration user.  These user permissions are then inherited by the integration.  

     

    The integration is going to directly  CRUD (Create, Read, Update, Delete) records in your database, records will be affected as the settings & rules for synchronization are setup. 

     

    The page layout, only controls what a user sees in the system via the UI based upon their profile, permissions, and the page layout you have assigned to them for the particular record type you assign the page layout to.

     

    As an example (very basic), lets say Hubspot was going to update a contact record first and last name (current values Jane Doe) and had the permission to do so via the modify all permission inherited by the integration user.  When the right scenario is triggered in Hubspot (let's say someone updates the contact in Hubspot to be John Doe) it will automatically update the First and Last name of the contact record, thus (Jane Doe would become John Doe in Salesforce).

     

    Now lets say that the page layout you had assigned to a particular user only shows the last name.  Before the update, even though values in the record are Jane Doe, only the last name of Doe is displayed to the user based on the page layout. 

     

    After the update, because the page layout only shows the last name, it would appear there is no change to the record, as the last name 'Doe' would still be displayed.  However the actual first name would have been updated to 'John' as the integration is updating the data directly at the data level, and is unhindered with page layout restrictions.  So people who utilize a different page layout which shows the first and last name would see the change to John Doe, while the user who has the more restrictive page layout would only see the Last Name 'Doe' and be unaware of the first name change.

     

    Page layouts really are only a UI level control.   They do  not really affect data access at the object level.  For that, you really would want to look at FLS, Profile, Permission set(s), and to a lesser degree page layout (depending on subset of data you want displayed to a user based on what they can view via the prior 3 settings)

     

    Hopefully this helps.

     

    Cheers,

    J.

0/9000

Hello all,

 

I'm hoping some architects can lend me some wisdom this morning as this challenge has left me stuck! Our sales organization utilizes an opportunity qualifying system called BANT and while I thought there might be a way to implement it into our sales process in Salesforce, I figured it was beyond my depth. 

 

Earlier this week I stumbled upon this slick solution demoed by Salesforce on their Youtube channel...How I Solved This  (shoutout to @Navigators Delivery @Jennifer (Jen) Lee ). For those of you without the time to watch it, Hayley uses custom metadata types, a custom object, & Flows to build a user-friendly wizard to log BANT-oriented questions and answers and to ultimately display BANT scores for each opportunity. You can imagine I was excited to see someone building an elegant solution for the very thing I hoped to bring into our org. While the demo is really well articulated, I tried my best to follow along and build out our own process using this example (and lots of pausing the video and squinting :)) but to no avail.

 

I'm able to build the custom metadata out as modeled in the video, but  I'm having trouble understanding once you build out your custom metadata how you get it to "talk to/interact with" the custom BANT Score object.  I have a feeling that's the key to setting up the flow properly but I'm out of my own ideas at this point. If it were possible to have a play by play of the same solution modeled in the video, that would be KILLER. Has anyone had success using metadata in this way? I think my brain is short-circuiting here :). 

 

Anyone able to help this lost admin make something really cool for their team?

 

#Salesforce Developer

 

@* Salesforce Developers *

5 answers
0/9000

@Here I would like to get some recommendations/experience on Light Weight ETL tools for enterprise. We are looking to have ETL Tool preferably Cloud based one's which are easy to use for Administrators basically to perform data extract, transform data and load to salesforce and get data out of salesforce and also export data to AWS from salesforce etc.. on a scheduled basis.  Any recommendations/inputs would be greatly appreciated. 

9 answers
  1. Sep 5, 2025, 7:02 PM

    I’ve worked with a few cloud ETL tools for this. Skyvia is one option that’s lightweight and admin-friendly. It can move data in and out of Salesforce, apply transformations, and export to AWS services on a schedule. You can check it here - https://skyvia.com/connectors/salesforce

0/9000

As an intermediate step, I'm thinking of utilizing the AWS S3 bucket - with AWS FLOWApp to link into Salesforce CRM - Lead Object.     I've only seen pulling data from SFDC , can I reverse the dataflow and load scheduled files into SFDC using the Flow? #Salesforce Developer

5 answers
0/9000

Hello everyone, I need help to get guides, tutorials and information on integrating Salesforces with Microsoft Onedrive or Sharepoint.  Thank you

7 answers
  1. Apr 3, 2025, 5:19 PM

    Hello, 

     

    Integrating Salesforce with Microsoft OneDrive can be done through several methods, depending on your specific needs and technical capacity: 

     

    1. Salesforce Files Connect. This is a native integration feature that allows Salesforce users to link to external storage systems like OneDrive. With Files Connect, you can access files from within Salesforce without actually storing them in Salesforce itself. Setting up Files Connect involves configuring the external data source in Salesforce, which can be a bit technical, but there are comprehensive guides available in Salesforce documentation.
    2. Third-party integration tools. If you’re looking for a no-code or low-code solution, you might want to explore tools like Skyvia. This platform allows you to integrate Salesforce with OneDrive with minimal setup. Skyvia supports automating data exchange between Salesforce and OneDrive, focusing on export and import scenarios rather than direct file synchronization. You can also schedule exports and imports to automate the replication of new or updated data. The platform offers an intuitive, no-code interface, making it easy to set up even for users without technical expertise.
    3. Manual Integration. For more customized use cases, manual integration via APIs can be an option. This approach requires coding and setup expertise. You can use the Microsoft Graph API to interact with OneDrive and Salesforce’s REST API for data management.
0/9000

We have a requirement to build a business rule engine for a claim process.We have lots of business rules. We also have to show all the applicable business rule which states that its error or warning.

Please suggest what is best possible way to achieve this.

Is there any open source which can be implemented in salesforce.

1 comment
0/9000

Hi all,

As some of you know, it is not possible to sync emails between Salesforce and Outlook if Einstein Activity Capture is not activated, I mean this is a possibility. Activating EAC implies additional costs for more than 100 users and you data is not stored in Salesforce anymore but in AWS.

I've heard about Revenue Grid and someone added the alternative Cirrus Insight.

What is your experience as user either of Revenue Grid or Cirrus Insight? Would you recommend it?.

@Cirrus Insight and Revenue Grid Sales reps, please do not use my thread to write "please contact me", I would appreciate.

My customer would like to send invitations to their event attendees and them to receive notifications when they are invited.

 

Looking forward to knowing what your experience was.

 

@Salesforce Administrators & Developers, @* Customer Architect Community *, @* Sales Cloud - Best Practices *, @Data Quality & Management

3 answers
  1. Dec 14, 2022, 7:53 AM

    Hi all,

     @Andrew Russo, thanks for sharing your experience. Aren't you afraid about the limitation with EAC that your data will be stored on AWS only 24 months and then deleted?. Aren't you afraid that AWS is storing confidential data of your org? 

    @Pamela Wakeman, is the tool expensive?. You can write me per Inbox if you think that information is something you can not share here (hopefully is that possible)

0/9000

Hi all,

Looking for AppExchange, flow or apex suggestions for this use case. Emails are coming as cases with pictures in the signature of the sender, which are then attached as Attachments in the created case (via E2C).

Images that are part of an email signature are ending up in the attachments related list.

Is there a way to avoid this?.

 

@Salesforce Administrators & Developers, @* Customer Architect Community *, @Data Quality & Management, @* Sales Cloud - Best Practices *

9 answers
0/9000

Dear Architects,

 

Need best practices and design considerations on developing new Mobile App in Salesforce to enterprise  customer, Any views are welcome.

Additional Info : Customer Need to connect to other system via this app.

1 answer
  1. Feb 5, 2022, 4:53 PM

    Vikas,

    Salesforce Mobile app is secured by default.

     

    For doing callouts, do it from Apex instead of JavaScript. You can use LWC or Aura Component. These components should utilize Apex for doing callouts(Integration).

     

    -- Magulan Duraipandian https://www.infallibletechie.com/

0/9000
6 comments
0/9000