jordannsa.blogg.se - Salesforce api vba request token

If your query has an empty result set, you will not get an array back from SFDC: you’ll get a null object that will cause error messages in your code if you try to do anything with it.

When you get a dateTime string from a query, it will be in this format: YYYY-MM-DD HH:MM:SS, but when you want to query based on a dateTime, you need to use this one: YYYY-MM-DDTHH:MM:SSZ.

So pay attention when a method’s return array is shown as being strings.

You’d think that the catch-all “Variant” array data type would be fine swallowing a string array… but it isn’t.

Use XL-Connector’s query-builder window to test any query string that you have.

When you’re working with queries, remember it’s only SOQL syntax, not full SQL.

The easiest way to automate is to use VBA to run Flow Steps that have been saved in your worksheet(s).

Set automationObject = Application.COMAddIns("TaralexLLC.SalesforceEnabler").Object And that means putting this code at the top of your VBA module or function: Dim automationObject As Object

You can’t record macros with XL-Connector buttons so you have to work with VBA code in order to do automation with the SFDC data.īefore you start, you have to get the XL-Connector COM addin properly instantiated in your worksheet’s memory space. You can use VBA to work with the underlying SFDC database access functions of XL-Connector.