Skip to main content
Question

Empty value converting JSON to Arcgis Online Feature Service

  • April 22, 2020
  • 2 replies
  • 36 views
A

Hi All. I am working on fme workbench to convert json data from api into Arcgis online feature service. Actually i am quite new on this software.

reader/ data link: https://covid19-public.digitalservice.id/api/v1/wilayah/jabar?level=kelurahan

However, when i run, and export it as ArcgisOnline feature service the data on the arcgis online is empty its actually consist more than 5000features.

feature service link: https://services6.arcgis.com/eV2M5wbf5ix69NmC/arcgis/rest/services/datajson22/FeatureServer

and the one that makes me more confuse is when i export the data into file geodatabase format, i could see the all data. here the image:

 

overall workflow on fme workbench:

 

 

attached:

fme workbench

 

 

could anyone share what is the main problem from this or how can i solve this.

Thankyou in advance

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

rahulsharma
Safer
Forum|alt.badge.img+10
  • rahulsharmaSafer
  • Safer
  • April 22, 2020

Hi @athaisyah,

 

It appears that attribute parent_bps - is set to type Integer and being rejected. See error below:
The `kode_bps' attribute could not be written. The containing feature has been dropped

WORKAROUND:

 

1. Change the datatype of this attribute to esriFieldTypeString

 

2. Delete the featureService from your AGOL account

 

3. Re-run the workspace

NOTE:

If you skip this step2 you will get the following error(As in schema the attribute is set as esriFieldTypeInteger)

ArcGIS Online Feature Service Writer: 'addResults' error for a feature in 'datajson22'. The error code from the server was '1000' and the message was: 'Arithmetic overflow error converting expression to data type int.
`The statement has been terminated.`
... Last line repeated 999 times ...
ArcGIS Online Feature Service Writer: 0 features successfully written to 'datajson22', but the server rejected the 1000 features in the last request due to errors. See warnings above. Aborting translation

0684Q00000ArK2DQAV.jpg

 

A
  • athaisyah
  • Author
  • April 26, 2020

hi @rahulsharma, Thanks a lot, it works now! I didnt recognize that tiny problem affecting the whole process. Thanks again

 

 

Community Stats

32,207
Posts
122,305
Replies
39,891
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.