nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to allow local file upload with the Analysis widget using a Custom web tool published from a Notebook (ArcGIS Online)

PatricePineaultWSP

In an experience builder, I need to allow users to upload an Excel file for further processing in a notebook published as a Custom web tool.

I created a notebook, configured the input parameters with a "file" type, declared it in the notebook code and published it.

In Experience Builder, I configured the analysis widget to use the published Custom web tool.

However, when configuring the Analysis widget, the checkbox "Allow local file upload" was disabled in the input parameter for the file.

I discovered that I could edit the json service file for the web tool (webtoolService.json) using ArcGIS Assistant and allow uploads with

"capabilities": "Uploads".

I can now enable the "Allow local file upload" option in the widget and I can click on the "upload" button then choose a local file to upload from my computer (small 1kb csv file). But when I do, I get the error:

"Error performing upload operation, file size or type not supported for this service"

What am I missing? I swear I could do this operation like 4-5 weeks ago when exploring the functionalities of notebooks and analysis widget.

Najděte více příspěvků označených jako

ArcGIS Online

Accepted answers

All comments

JaredPilbeam2

Hi @xlt208 @PatricePineaultWSP @MarcHoogerwerf_EsriNL,
Any update? Trying to get a script tool imported into ExB to upload a locally stored table (xlsx, csv) seems impossible. The Add Data Tool was the only thing that allowed what seems like such a simple task and that is currently suffering from a BUG that errors on a CSV with an 'Address' field.

xlt208

Hi @PatricePineaultWSP @MarcHoogerwerf_EsriNL, thank you for the detailed information! Currently, notebook web tools only support input files provided via a URL or an item from the content. We are actively exploring the possibility of supporting file uploads directly within the tool interface. We appreciate your feedback!

MarcHoogerwerf_EsriNL

Hi Wei Ying,

I'm trying to do a similar thing from a WebTool published from an ArcGIS Online Notebook. However, the services directory seems to be disabled for the WebTools published from online notebooks. Is this a permission issue or is it disabled across the board? Is there any way to enable local file uploads to a Webtool?

Currently this is a showstopper for a customer who is planning to move their entire GIS operation from ArcGIS Enterprise to ArcGIS Online. A common workflow in many of their domains is allowing users to upload project files (Excel, CSV, images, CAD files) to a GP service that process them and adds the results to a company wide repository (hosted feature layers, image mosaics, oriented imagery layer, etc).

I've updated webtoolService.json with entries for capabilities, maxUploadFileSize and allowedUploadFileTypes

{
    "currentVersion": 11.4,
    "cimVersion": "2.9.0",
    "serviceDescription": "uplolad excel",
    "executionType": "esriExecutionTypeAsynchronous",
    "resultMapServerName": "",
    "maximumRecords": 1000,
    "capabilities": "Uploads",
    "maxUploadFileSize": 2000,
    "allowedUploadFileTypes": "xlsx,xls",
    "tasks": [
        "Upload_Excel"
    ],
    "serviceUrl": null,
    "timeoutInMinutes": 15
}

So allow local file upload is now enabled in Experience Builder

But I'm getting this error when selecting a small .xlsx from my local machine

I opened up DevTools to see what's happening when I try to upload the .xlsx file.

https://notebookswebtools.arcgis.com/arcgis/rest/services/5492156d2f0c48caaee9b7f03febdc50/GPServer/uploads/upload?token=<token_here>

It fails with a 400 Bad Request Error:

curl ^"https://notebookswebtools.arcgis.com/arcgis/rest/services/5492156d2f0c48caaee9b7f03febdc50/GPServer/uploads/upload?token=<token_here>^" ^
-H ^"Accept: */*^" ^
-H ^"Accept-Language: en-US,en;q=0.9^" ^
-H ^"Connection: keep-alive^" ^
-H ^"Content-Type: multipart/form-data; boundary=----WebKitFormBoundaryugnpt6fxyHxjo6jc^" ^
-H ^"Origin: https://experience.arcgis.com^" ^
-H ^"Referer: https://experience.arcgis.com/experience/2079130ecf924c77a08f3f56a8df2cc6?draft=true^" ^
-H ^"Sec-Fetch-Dest: empty^" ^
-H ^"Sec-Fetch-Mode: cors^" ^
-H ^"Sec-Fetch-Site: same-site^" ^
-H ^"User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36 Edg/135.0.0.0^" ^
-H ^"sec-ch-ua: ^\^"Microsoft Edge^\^";v=^\^"135^\^", ^\^"Not-A.Brand^\^";v=^\^"8^\^", ^\^"Chromium^\^";v=^\^"135^\^"^" ^
-H ^"sec-ch-ua-mobile: ?0^" ^
-H ^"sec-ch-ua-platform: ^\^"Windows^\^"^" ^
--data-raw ^"------WebKitFormBoundaryugnpt6fxyHxjo6jc^

Content-Disposition: form-data; name=^\^"file^\^"; filename=^\^"Test.xlsx^\^"^

Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet^

------WebKitFormBoundaryugnpt6fxyHxjo6jc^

Content-Disposition: form-data; name=^\^"f^\^"^

json^

------WebKitFormBoundaryugnpt6fxyHxjo6jc^

Content-Disposition: form-data; name=^\^"token^\^"^

<token_here>^

------WebKitFormBoundaryugnpt6fxyHxjo6jc--^

Then I had a look at the request that was done before the upload request:

https://notebookswebtools.arcgis.com/arcgis/rest/services/5492156d2f0c48caaee9b7f03febdc50/GPServer?f=json&token=<token_here>

And got this response

{
    "currentVersion": 11.4,
    "cimVersion": "2.9.0",
    "serviceDescription": "Upload Excel Nieuw",
    "executionType": "esriExecutionTypeAsynchronous",
    "resultMapServerName": "",
    "maximumRecords": 1000,
    "capabilities": "Uploads",
    "tasks": [
        "Upload_Excel"
    ],
    "timeoutInMinutes": 15
}

So, obviously, the service doesn't allow my Excel files to be uploaded. The allowedUploadFileTypes I specified in the webtoolService.json don't end up in the service definition.

Am I missing something? Is there another place where I can specify allowUploadFileTypes? In ArcGIS Enterprise I can get to the right place to edit the GPService definition, but where should this be done in AGOL?

Wei_Ying

CVS and XLSX are supported to be upload as long as your gp service allow to do so.
You have to check with the gp service on server admin side, such as. Please contact your server admin maybe to help verify the supported type for the gp service you are using.

PatricePineaultWSP

Hi,

1.16.0
At the moment, CSV. But need it to be XLSX
https://notebooksservices3.arcgis.com/admin/services/<myToolId>.GPServer There are no properties about "Max upload file size" or "Allowed upload file types"

Wei_Ying

@PatricePineaultWSP Thanks for reaching out. Some questions:
1. What version of ExB are you using?
2. What type of the file you are trying to upload?
3. Can you check your web tool service's admin point see its allowing file types and max file size.
Such as "https://domainname/server/admin/services/Tooname.GPServer"

Připojte se k diskusi

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.