This tutorial will help you learn how to read data from and write it to EditGrid spreadsheets in Apatar.

Configuration

To configure the connector for EditGrid, please follow these steps:

1. First you need to add Apatar as a 3rd party application that can work with EditGrid and obtain App Key. Go to your EditGrid account. Click Navigation button and in the Developer section choose Developer Tool. Then click Setup New Application, enter name "Apatar", and click Submit. Now you have the App Key. Then go to the Account Preferences - Public Access and change Default public access level for new spreadsheets from Private to Read-Write for once. Let Apatar connect to EditGrid. Then you may change the access to any level. You will not need to repeat this afterwards, as it is only a one-shot job, and Apatar will connect to an account no matter if it has a private level or any other.
   
   
   
   
2. Drag-and-drop the connector to Apatar's work panel.
3. Double-click on the node to set its properties.
4. Fill in the property fields.
   
   
   
   
   • Data direction:
     
     
     
     
     
     
   • Offset indicates the first record position
   • FirstFieldPosition indicates the first field position
   • LastFieldPosition indicates the last field position
   • FirstFieldName is a flag to indicate if you want to treat the values in the first row/column (depending on data direction value) as column names
   • SkipEmptyRecords is a flag to indicate if you want to skip empty rows/columns in specified range.

     	Property Name	Control Type	Mandatory	Valid Values
     1	organisation	Field	No	Mandatory if using Organisation account
     2	userName	Field	Yes
     3	password	Field	Yes
     4	appKey	Field	Yes
     5	dataDirection	List	Yes	"VerticalDirection" (default) or "HorizontalDirection"
     6	offset	Field	Yes	Integer value greater or equal to 1
     7	firstFieldPosition	Field	Yes	Integer value greater or equal to 1
     8	lastFieldPosition	Field	Yes	Integer value greater or equal to FirstFieldPosition
     9	firstFieldName	Checkbox	Yes
     10	skipEmptyRecords	Checkbox	Yes

5. Press Next.
6. If all of the previous steps were completed correctly, you will see the list of available workbooks at your EditGrid account. Make a selection.
   
   
   
   
7. Press Next. A list of the worksheets should occur. Make a selection.
   
   
   
   
8. Press Next. A list of the worksheet columns should occur.
   
   
   
   
9. Choose the Mode you would like to work with and press Finish.

Preview

Now you can preview the data. To do so, right-click on the node and select Preview Results.