How to load excel data into table with rest api.

[santhoshbannu]

The system shall retrieve and display external files in both Excel (.xlsx) and JSON (json) formats using
REST API integrations.

Please idk how to do ... Tell me

[Ankur Bawiskar]

@santhoshbannu 

so 3rd party will send excel file and you need to load data?

what's the actual business requirement?

what type of API you are planning to use?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[santhoshbannu]

yes 3rd part excel data we need to send into a instance in a table format with use of rest api.

[Ankur Bawiskar]

@santhoshbannu 

you can use a scripted REST API, it will attach file to data source, then transformation can be kicked off

check these links on how that can be done, it's in bits and pieces but they should help you get started

Sending attachments using custom scripted web service 

Convert .csv file to .xlsx file and auto import to target table received attachment via email 

If my response helped please mark it correct and close the thread so that it benefits future readers.