I am Testing for matches json.ID against SDE db sde.ID. The problem is no matches yet there are 26 matches in the test case. I think I have a data typing error. The sde.ID is VARCHAR2 (30 Byte) and I assume the json.ID is data source json. ANyway to covert to get a matchup??
Page 1 / 1
Hey @dbklingdom thanks for your post!
Data type in your underlying database may be a blocker in this situation, but it could also be an attribute formatting error. It's hard to tell without seeing your workflow. For example, how are you performing the matching? Would you be able to provide a sample of the data you are trying to match and a test workspace to play around with?
Thanks,
Nathan
OK this can get you setup. I just the spreadsheet and still not getting the data to follow in the right direction, si I'm concentrating json side? Thx
OK my bad I have used featureMerger to bring the two tables together first!!
devicestatusinfo.xlsx
FME is still looking at this as json. Looks like each row is a list??
Besides our JSON transformers, FME supports a wide variety of list manipulation transformers which might help out in this situation. You can get started with lists by peeking at our list attribute tutorials here.
Best,
Nathan
devicestatusinfo.xlsx
FME is still looking at this as json. Looks like each row is a list??
What field or fields are you having trouble with in particular? Could you narrow down your problem and give an example of your input and expected output? It looks like your result{} list has been properly exploded into singular attributes. Is it the group{}.id values you're concerned about?
Besides our JSON transformers, FME supports a variety of list manipulation transformers which may be what you're looking for in this situation. It might help to get started with our list attribute tutorials.
Nathan
OK this can get you setup. I just the spreadsheet and still not getting the data to follow in the right direction, si I'm concentrating json side? Thx
From what I can tell, your result{} list has been properly converted into singular attribute values. Is it the group{} list that you're concerned about with regards to matching? Could you isolate the issue you're having and provide an example of your input and the expected output? Or what you would expect to find matching?
Besides our JSON transformers, FME supports a wide variety of list manipulation transformers which might help out in this situation. You can get started with lists by peeking at our list attribute tutorials here.
Best,
Nathan
OK my bad I have used featureMerger to bring the two tables together first!!
If you did this also, they have two output types: DOTNET and Java Script - which one did you pick?
https://my.geotab.com/sdk/#/dataFeedExample
Paul