I'm building a small PoC where i need to write to an Excel spreadsheet. i need to save my data in certain cells positions.Everything i'm finding points me to use the Export dataStore to Excel Smart service and to specify those cells positions in the node input using the twocustom cell position / custom cell values.My problem is i don't have a CDT to load from, this is a purely sync records PoC. do I really have to build a CDT structure to get this to work ?
Discussion posts and replies are publicly visible
From what I saw, it seems like the Export DSE to Excel Smart Service is the recommended approach at this time - the alternative being the Export SQL to Excel Plug-in. It shouldn't be too difficult to build out the CDT if you already have the record type though. You can select "Create from database table or view" when creating the CDT and just reference the table associated with the Record Type. You can create the DSE at the same time.
When you say you are using purely synced records - are you talking about pulling data from an external system like Salesforce, or synced records from an internal database?