topic Re: Arcade dictionary to FeatureSet in Developers Questions

Arcade dictionary to FeatureSet

MarcHoogerwerf_TAP — Wed, 14 Apr 2021 16:59:52 GMT

Hi,

I'm trying to convert a dictionary to a FeatureSet in an Arcade data Expression. Everything works well until I use a Date field.

The following works ok, just inserting null values for the date field

var data_dict = {
'fields': [
{'name': 'EditDate','type': 'esriFieldTypeDate'},
{'name': 'country','type': 'esriFieldTypeString'},
{'name': 'status','type': 'esriFieldTypeInteger'}
],
'geometryType':'',
'features': []
};

for (var i=0; i < 10;i++) {
data_dict.features[i] = {
'attributes': {
'EditDate': null,
'country': 'NL',
'status': 230
}
}
}
Console(data_dict)
var fs = FeatureSet(Text(data_dict))
return fs

It results in a FeatureSet with empty values for the date field and all other field filled.

However, if I try Now() or Text(Now(),"YYYY-MM-DD") or Timestamp() or just a date like string '2021-04-14' :

var data_dict = {
'fields': [
{'name': 'EditDate','type': 'esriFieldTypeDate'},
{'name': 'country','type': 'esriFieldTypeString'},
{'name': 'status','type': 'esriFieldTypeInteger'}
],
'geometryType':'',
'features': []
};

for (var i=0; i < 10;i++) {
data_dict.features[i] = {
'attributes': {
'EditDate': Now(),
'country': 'NL',
'status': 230
}
}
}
Console(data_dict)
var fs = FeatureSet(Text(data_dict))
return fs

I end up with an empty Featureset

Any ideas?

Regards,

Marc

Re: Arcade dictionary to FeatureSet

Anonymous User — Fri, 16 Apr 2021 23:32:41 GMT

Hi @MarcHoogerwerf_TAP - the date field is looking for a UNIX timestamp, which you can create in Arcade with DateDiff().

var start = ToLocal(Date(1970, 0, 01, 0, 0, 0, 0)) var dt = DateDiff(Now(), start, 'milliseconds')

Hope this helps!

-Peter

Re: Arcade dictionary to FeatureSet

MarcHoogerwerf_TAP — Sat, 17 Apr 2021 04:54:26 GMT

Hi Peter,

Brilliant! It works now. Thanks

- Marc

Re: Arcade dictionary to FeatureSet

DavidPike — Sun, 09 May 2021 17:27:04 GMT

@Anonymous User was scratching my head for a while on this, after a quick google it led me here - thanks for your solution.

Re: Arcade dictionary to FeatureSet

Anonymous User — Mon, 10 May 2021 15:17:25 GMT

Glad it was a quick find and helped out!

Re: Arcade dictionary to FeatureSet

DarrylKlassen1 — Wed, 29 Dec 2021 23:07:18 GMT

This is great, i have been struggling with this for over a day. Thanks for the help.

Re: Arcade dictionary to FeatureSet

Anonymous User — Tue, 29 Nov 2022 15:38:28 GMT

Hi @Anonymous User, I'm tying to figure out where I would assign the "dt" variable within my dictionary. See Expression below. I'm having the same issue, in which the "CloseOutDate" field is not populating.

Re: Arcade dictionary to FeatureSet

Anonymous User — Tue, 06 Dec 2022 23:53:57 GMT

@Anonymous User you can remove the variable line 'var dt = ...' completely as you're not wanting to get the date diff for Now(), as that's the current date at time of execution, instead you'll use your field value date to replace the Now(). For each of the date fields, in each featureset update them to the following but change the feature variable to be relevant i.e. t or m:

CloseOutDate: DateDiff(t["CloseOutDate"], start, 'milliseconds')

Re: Arcade dictionary to FeatureSet

Anonymous User — Wed, 07 Dec 2022 00:02:30 GMT

Hi @Anonymous User what's the method for using an existing date field, coming from an exisitng FeatureSet, in a dictionary i.e. @Anonymous User's post below?

Having to do a DateDiff for each date field seems overly complicated. I'm guessing there are some smarts whereby the date field is automatically being converted to text on execution, instead of an epoch as the example from this page (below) https://developers.arcgis.com/arcade/function-reference/date_functions/#date doesn't work:

var recordDate = Date($feature.dateField)

Thanks

Re: Arcade dictionary to FeatureSet

Anonymous User — Thu, 08 Dec 2022 02:19:30 GMT

That did the trick! Thanks so much for the help.

Re: Arcade dictionary to FeatureSet

RobertAnderson3 — Wed, 19 Apr 2023 15:02:31 GMT

This was a huge help, the problem I was then running into was in using data from Survey123 it did not have the time zone correct and I could not figure out why.

I ended up using Number() around my date and it worked out, but I'm curious about the time zone issues I had with DateDiff. Even with Now() it is off by -4 hours, I'm in ADT (-3) which is (-4) when AST. Survey123 is right but the dashboard seems to compensate a second time?

Re: Arcade dictionary to FeatureSet

DavidNyenhuis1 — Thu, 15 Jun 2023 19:22:05 GMT

With this week's update to Arcade and ArcGIS Dashboards, date fields in feature set constructors now just work. You no longer have to wrap dates with Number() if you pass the dictionary into the FeatureSet() function (which as of this release accepts a dictionary as opposed to only text based JSON).

Instead of:

return FeatureSet(Text(dict))

Do this:

return FeatureSet(dict)

Learn more in this blog post.

NOTE: For Enterprise users, this update is targeted for 11.2

Re: Arcade dictionary to FeatureSet

DavidNyenhuis1 — Thu, 15 Jun 2023 19:30:27 GMT

With this week's update to Arcade and ArcGIS Dashboards, date fields in feature set constructors now just work. You no longer have to pass dates in as EPOCH if you pass the dictionary into the FeatureSet() function (which as of this release accepts a dictionary as opposed to only text based JSON).

Instead of:

return FeatureSet(Text(dict))

Do this:

return FeatureSet(dict)

Learn more in this blog post.

NOTE: For Enterprise users, this update is targeted for 11.2