POST
|
PART 2 Create your temporary token 1) To receive your token for your application replace CLIENTID and CLIENTSECRET with your own. https://www.arcgis.com/sharing/rest/oauth2/token/?client_id=CLIENTID&client_secret=CLIENTSECRET&grant_type=client_credentials 2) New query, from web and enter the url with your IDs. 3)choose advanced > ok 4) Choose EDIT 5) Select Data Source Settings 6) Change Source and select open file as JSON. 7) press advanced editor, we'll now edit the code so that it points to our tables. modify to code to let //Custom Variables access = Excel.CurrentWorkbook(){[Name="AGOL_ACCESS"]}[Content], client_id = access{0}[Value], client_secret = access{1}[Value], Source = Json.Document(Web.Contents("https://www.arcgis.com/sharing/rest/oauth2/token/?client_id=" & client_id & " &client_secret="& client_secret & "&grant_type=client_credentials"), 65001), #"Converted to Table" = Record.ToTable(Source) in #"Converted to Table" By having variables you'll now be able to reuse this excel table for other application tokens, as it points to the table that you previously created. Next you'll need to get the service URL for your feature layer... PART 3 coming...
... View more
08-23-2019
05:14 AM
|
10
|
18
|
11889
|
POST
|
Still travelling but I'll try to summarize best I can here: PART 1: CREATE TOKEN ArcGIS for Developers Sign into the same AGOL account that holds your survey feature layer Select New Application d.Give your application a name, then click "Register" e. Note the Client ID and Client Secret IN EXCEL: Insert three Tables Enter the Client ID and Client Secret you just copied from the application you just created. I like to name my tables; From Top to bottom: AGOL_ACCESS, Token_auto, Hosted_FS0
... View more
08-23-2019
04:37 AM
|
3
|
19
|
11889
|
POST
|
Just saw this, I'll put together the how-to to help you out.
... View more
08-08-2019
02:56 PM
|
0
|
22
|
11888
|
POST
|
Hi Michelle, I believe I removed this {"editMode":1,"globalIdField":"globalid","objectIdField":"objectid"}
... View more
06-11-2019
06:05 PM
|
0
|
0
|
3074
|
POST
|
Found a Solution on updating repeats within repeats. I added the fields through Arcgis online, then republished the survey on survey123 connect. Connect did not need to add the 2 new fields and only needs to update the form. Perfect.
... View more
12-10-2018
03:12 PM
|
0
|
0
|
511
|
POST
|
Ok so I've pinpointed the publish error... it is when I try to add a field to a repeat within a repeat. Is there any way I can do modifications to this repeat within a repeat?
... View more
12-10-2018
12:52 PM
|
0
|
1
|
511
|
POST
|
I'm getting a similar error when I add a new variable to my survey. Ran a log and the error I see if <12>1 2018-12-10T20:11:24Z RPTORWK008 Survey123ConnectforArcGIS 9176 - [AppStudio@11205 category="default" filename="PublishSurvey.qml" line="511"][check] qrc:/qml/Connect/PublishSurvey.qml:511: TypeError: Cannot read property 'fields' of undefined any idea?
... View more
12-10-2018
12:30 PM
|
0
|
2
|
1110
|
POST
|
Ok so I figured it out, I thought I could save some time by having the relevance on a group containing the required questions, but it looks like you need a relevant logic on each required question in order for them to be validated.
... View more
11-29-2018
02:27 PM
|
0
|
0
|
2486
|
POST
|
Thanks James, note that there are many null columns.
... View more
11-29-2018
12:33 PM
|
0
|
1
|
2486
|
POST
|
I'm using version 3.0.127 and I'm still having this error, required questions within a group that is not relevant are being flagged
... View more
11-29-2018
11:57 AM
|
0
|
3
|
2486
|
POST
|
I can't share publicly, but message me privately please.
... View more
06-05-2018
08:57 PM
|
0
|
1
|
578
|
POST
|
One of my tablets crashed and the surveys disappeared from the application. I copied the .sqlite database to my computer (~8mb) but when I open it the "Surveys" table appear empty. However, when I opened the sqlite in notepad ++ , I can see that the surveys are still there. I've followed various recovery measures, such as Procedure to recover a corrupted SQLite3 ArcGIS Mobile cache database, but they only dump an empty table. I've reverted back to a previous .sqlite backup but since this is the first time that I've had an .sqlite database corrupt with Survey123 I was wondering if anyone else has had this happen and what you did to repair the database.
... View more
06-05-2018
01:51 PM
|
0
|
3
|
803
|
BLOG
|
I was thinking of using a word template, fill in using the the output from the web hooks, then send it as a report through email. I however don't see the attachments (imagery) as an output in the webhooks. Is this possible?
... View more
06-01-2018
06:16 PM
|
0
|
0
|
8736
|
POST
|
I constantly get this question so I decided to put a post on converting these 12 digit unix epoch dates (timestamp is in milliseconds) that you get when exporting your geodatabase. Excel: =(A1/86400/1000)+25569 *Don't forget to set the type to Date on your output cell. Power Bi: let Source = #table({"Epoch"},{{1486933998060}}), #"Added Custom" = Table.AddColumn(Source, "Custom", each #datetime(1970,1,1,0,0,0)+#duration(0,0,0,[Epoch]/1000)) in #"Added Custom" e.g. Access: Format dd/mm/yyyy hh:nn:ss e.g. epoch datetime calculation gdb to excel access power bi unix #date
... View more
05-31-2018
06:43 PM
|
6
|
1
|
23475
|
POST
|
Wanted to add that with Excel powerquery you may also show the URL to your hosted feature attachments. 1) Create the Query to your attachment table 2) Customize a column; = SERVICEURL & parentObjectId & "/attachments/" & attachmentID & Token You can then open all your attachments using the hyperlink from your custom column (note that your token will need to be constantly refreshed). BONUS: With a little VBA you can then download all your photos to a local folder using the attachment URL. (modified from excel - Convert code for 32 bit to 64 bit - Stack Overflow ) *update: Added a line to add images that are not already present in the folder, reducing downloading time. Option Explicit
Private Declare Function URLDownloadToFile Lib "urlmon" _
Alias "URLDownloadToFileA" (ByVal pCaller As Long, _
ByVal szURL As String, ByVal szFileName As String, _
ByVal dwReserved As Long, ByVal lpfnCB As Long) As Long
Dim Ret As Long
Sub Download_image_structure()
Dim ws As Worksheet
Dim LastRow As Long, i As Long
Dim countupdate As Long
Dim strPath As String
Dim FolderName As String
Dim fs
Set fs = CreateObject("Scripting.FileSystemObject")
FolderName = "W:\IMAGES\STRUCTURE\" '<-- folder where images will be saved
'~~> create folder if it does not exist
If Len(Dir(FolderName, vbDirectory)) = 0 Then
MkDir FolderName
End If
'~~> name of sheets with image to download
Set ws = Sheets("STRUCTURES_PHOTO")
LastRow = ws.Range("A" & Rows.Count).End(xlUp).Row
For i = 2 To LastRow '<~~ 2 because row 1 has headers
strPath = FolderName & ws.Range("F" & i).Value
If Not fs.FileExists(strPath) Then '<-- if image does not exist in folder then skip to next
Ret = URLDownloadToFile(0, ws.Range("I" & i).Value, strPath, 0, 0)
countupdate = countupdate + 1
End If
Next i
MsgBox countupdate & " added images" '<-- how many image added to folder
End Sub
... View more
04-25-2018
04:39 PM
|
5
|
0
|
11888
|
Title | Kudos | Posted |
---|---|---|
1 | 08-30-2017 12:55 AM | |
1 | 10-21-2017 06:39 AM | |
3 | 03-07-2018 03:04 PM | |
1 | 11-22-2017 05:30 PM | |
1 | 11-23-2017 05:41 PM |
Online Status |
Offline
|
Date Last Visited |
11-11-2020
02:25 AM
|