Is there a way to generate JSON to correspond to the record for the Defaults tab on a SQL import step? Is there any doc/help or other resource out there to explain how to use the Defaults tab? It seems like something potentially very helpful that could greatly reduce the need for handlebar expressions for every field, but no doc or help can be found anywhere!
Jim
Hi @Jim_Clarke 
Just to clarify—are you hoping to create an SQL import query based on the export JSON? If so, that’s not something we currently support, but I’d be happy to add it to our Product Feedback board. We really appreciate suggestions like this; they help us improve the experience for everyone!
@Jim_Clarke May I know which database application are you referring to here ?
Defaults tab help you to provide default values for the columns. You can find the article here.
Thanks for the response. I checked that article, and all it does is say to use that tab to create defaults, and provides a very simple example. It’s very thin on details. However, after a fair amount of testing, I determined that if you create a new step from scratch, it will create default JSON for all of your record fields with default = ““. If you copy a step from another, it seems like it copies all of the defaults/fields from the other flow, which may be completely wrong for your current flow. Also, it seems like for many of my steps, that tab is empty. It would be nice to have a button on that page/tab that regenerates JSON for all your record fields. Otherwise I have to temporarily create another import step in the same flow, copy the defaults, and then discard the new step. Then I can paste the defaults into my existing step.
I am using the Microsoft SQL Server connector.