ConfiForms

Space shortcuts

Expand all   Collapse all
Child pages
  • Using Excel files as sources for ConfiForms fields

Versions Compared

Old Version 20

changes.mady.by.user Alex Medved

Saved on

compared with

New Version Current

changes.mady.by.user Alex Medved

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

These 2 APIs are available at the following URLs:

File formatAPI URLMethod
Excel 97-2004 (xls)

https://YOUR_CONFLUENCE_SERVER/ajax/confiforms/rest/excel-2json.action

Status
colourBlue
titleSINCE 3.14.5

/rest/confiforms/1.0/excel/{attachmentId}

GET
Excel (xlsx)

https://YOUR_CONFLUENCE_SERVER/ajax/confiforms/rest/excel2007-2json.action

Status
colourBlue
titleSINCE 3.14.5

/rest/confiforms/1.0/excel2007/{attachmentId}

GET
CSV (default format)

https://your_confluence_server/ajax/confiforms/rest/csv-2json.action

Status
colourBlue
titleSINCE 3.14.5

/rest/confiforms/1.0/csv/{attachmentId}

GET


Services expect/support the following parameters:

...

We have defined new connection to use the above mentioned excel to JSON APIs


Image RemovedImage Added

And set the mapping to use cell1 as ID column for the dropdown and cell2 as a label

...