Uploaded image for project: 'Red Hat Fuse'
  1. Red Hat Fuse
  2. ENTESB-11273

Google spreadsheets changes datatype when Column names are not set

XMLWordPrintable

    • % %
    • Not applicable
    • Hide
      1. Start integration with DB connector with query `SELECT * FROM contact`
      2. As a finish step choose gogole sheets connection with action `Update sheet values`
      3. Fill values range: E1:E5, Major dimension: Columns
      4. Leave Column names empty
      5. Add datamapper in between start and finish
      6. `Could not load JSON document, error: Json data and Instance or Schema inspection type must be specified in request ` should show up in the datamapper UI and the Gsheets connector should have json-schema datatype defined
      Show
      Start integration with DB connector with query `SELECT * FROM contact` As a finish step choose gogole sheets connection with action `Update sheet values` Fill values range: E1:E5, Major dimension: Columns Leave Column names empty Add datamapper in between start and finish `Could not load JSON document, error: Json data and Instance or Schema inspection type must be specified in request ` should show up in the datamapper UI and the Gsheets connector should have json-schema datatype defined
    • Fuse 7.5 Sprint 52 - Bug fix

      When using Update sheet values in Google sheets connector and leaving the Column names input empty, the datatype changes from ValueRange Parameter to JSON.
      Which causes the Data Mapper step to fail with `Could not load JSON document, error: Json data and Instance or Schema inspection type must be specified in request `

            christoph.deppisch Christoph Deppisch
            mmuzikar Martin Muzikar
            Martin Muzikar Martin Muzikar
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: