×

Please give details of the problem

Docs

Find

    Developer Guide

    1. Composite API Example
      1. Scripted Lanes
      2. Compound Organization Hierarchy
      3. Dynamic Lanes
      4. Delegation
      5. Access Rights
      6. Runtime Lanes
        1. Todo Validation
      1. Release Your User Login
      1. Collections To Array
      2. Collections To List
      3. Collections BackOffice
      4. Collection JS Freemarker
          1. Composite API Design Tab
          2. Composite API Configuration Tab
          1. Providers
          2. Connectors
          3. Processes
          1. Roles entities
          2. Organization
        1. Collections
          1. Project Files Tab
          2. Project Definition Tab
          3. Project Versioned Files Tab
          4. Project Version Tab
          5. Project Description Tab
          6. Version
          7. Project Rights Tab
          8. Project Collection Tab
          1. Web Interface JS Tab
          2. Web Interface Design Tab
            1. Image Widget
            2. FileUpload Widget
            3. StaticText Widget
            4. ProgressBar Widget
            5. TextInput Widget
            6. JavaScript Widget
            7. Section Widget
            8. Geolocation Widget
            9. Checkbox Widget
            10. RadioButton Widget
            11. Tree Widget
            12. Spinner Widget
            13. History Widget
            14. URLInput Widget
            15. Tab Widget
            16. List Widget
            17. Array Widget
            18. HTML Editor Widget
            19. Report Widget
            20. Button Widget
            21. Custom Widget
            22. Captcha Widget
            23. HTML Widget
            24. Multi Checkbox Widget
          3. Web Interface Analytics Tab
          4. Web Interface Collection Tab
          5. Web Interface Implementation Tab
          6. Web Interface API Tab
          7. Web Interface Stylesheet Tab
        2. Revision
        3. Custom Lists
          1. Process Variables Tab
          2. Process Measures Tab
              1. Process Timer Event
              2. Process Start Event
              3. Process Intermediary Event
            1. Gate
              1. Process Task Loop Tab
              2. Process Task Manual Tab
              3. Process Task Email Tab
              4. Process Task Connector Tab
              5. Process Task SubProcess Tab
              6. Process Task Functional Tab
              7. Process Task Script Tab
            2. Process Step Output Variables
            3. Process Step Testing Variables
            4. Process Step Input Variables
          3. Process General Tab
          4. Process Design
          5. Process Input Tab
        1. Home
        2. My Applications
        3. Files
      1. Customer Management
        1. Messages
        2. Scheduled Process
        1. Process Examples
        2. Connectors
        1. Users
        2. Configuration
        3. Usage
        1. Web Interface Reports
          1. Measuring
          2. Runtime Users
          3. Execution Path
          4. Parameters
        1. CSS Examples
        2. CSS Personalization
      1. Performance
        1. Logout
        2. Redirection ExecutionMode
        3. Information Tags
        4. Basket
        5. Menu Bar
        6. Header
        7. Custom Login Page
        8. Mobile Devices
          1. homepage.css
          2. homepage.js
        1. Inject JSONObject
        2. Google Tables
        3. ArrayJSON to JSONArray
        4. Label Modification
        5. Number Currency Format
        6. Launch Process JQuery
        7. Date
        8. JQuery
        9. Round
        10. Holidays
        11. Array From WS
        12. Column Inactivation
        13. Print JSONObject
        14. Initialization Widget Date
        15. Invalid Fields
        16. List Reinitialization
        1. Tags
        2. Dialog Window
        3. Dynamic List
        4. User Lane Picker
          1. Report Chart
          2. Google Visualization
          3. Chart Dashboard
          4. Chart Dashboard Collection
        5. API Listener
        6. JavaScript Report
        7. Retrieving Variables Values
        8. Collection
        9. File Preview
        10. Autocomplete Widget
        11. Summing Array
      1. Trigger
      2. Markdown Template
        1. Task Reminder Email
        2. JavaScript Inclusion
        3. PDF
        4. SubProcess
        5. Backloop
        6. Variable Mapping
        1. Salesforce Computation
        2. Number Currency Format
        3. List Hash Sequence
        4. JSONObject Creation
        5. Freemarker Container Test
        6. JSONObject Concatenation
        7. Metadata
        8. Special Freemarker Characters
        9. List 1000+ Objects
        10. Dynamic Variable
        11. File Visibility
        12. Number Test
        13. JSONObject Keys Values
        14. Lock
        15. JSONArray Conversion
        16. Error Handling
        17. Loop
        18. Array To List
      1. Process Reporting API
      1. Offline
      2. Mobile

    How to convert an Array to a JSONObejct and vice versa

    To dump a RMP array (json of arrays) to a google spreadsheet, you have to create an array of jsons : you'll have to use ${transpose(my_array). To dump the rows of a google spreadsheet (array of jsons) to a RMP array (json of arrays), you have to use ${transpose_1(my_array)} defined below.

    Code

     1
     2
     3
     4
     5
     6
     7
     8
     9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28
    29
    30
    31
    32
    33
    34
    35
    36
    37
    38
    39
    40
    41
    42
    43
    44
    <#function transpose_1 my_array my_keys=[]>  
    ${my_array?size}  
    <#if my_array?is_sequence>  
    <#if (my_array?size>0)>  
    <#if (my_keys?size!=0)>  
    <#assign array_keys = my_keys>  
    <#else>  
    <#assign array_keys = []>  
    <#list my_array[0]?keys as x>  
    <#assign array_keys = array_keys + [x]>  
    </#list>  
    </#if>  
    </#if>  
    <#assign my_result = {}>
    
    <#list array_keys as x>  
    <#assign my_col = []>  
    <#list my_array as y>  
    <#assign my_col = my_col + [y[x]?default("")]>  
    </#list>  
    <#assign my_json = "{\"" + x + "\":" + my_col + "}">  
    <#assign my_json = my_json?eval>  
    <#assign my_result = (my_result + my_json)?eval>  
    </#list>  
    <#else>  
    <#assign my_result = "error while executing function tranpose_1">  
    </#if>  
    <#return my_result>  
    </#function>
    
    <#assign my_array = {"col1":["a","b"],"col2":["c","d"],"col3":["e","f"]}>
    
    ${my_array}  
    <#assign my_array1 = transpose(my_array)>  
    ${my_array1}  
    ${transpose_1(my_array1)}  
    ${transpose_1(my_array1,["col1","col2"])} <#-- to retrieve only columns col1 and col2 ( not col3)
    
    <#-- will return -->
    
    {"col1":["a","b"],"col2":["c","d"],"col3":["e","f"]} <#-- json of arrays -->
    [{"col1":"a","col2":"c","col3":"e"},{"col1":"b","col2":"d","col3":"f"}] <#-- array of jsons -->
    {"col1":["a","b"],"col2":["c","d"],"col3":["e","f"]}
    {"col1":["a","b"],"col2":["c","d"]}