AnsweredAssumed Answered

I have a file with JSON Request, each Key is mapped with DB Cols. How to compare a file with DB Rows ?

Question asked by PreethiManoj on Aug 24, 2017
Latest reply on Aug 29, 2017 by gajsr01

Hi Team,

 

Good Evening...

 

I have a Source system as a "dat file" in json format. Below is one of the request. When i run the interface, the Values in the JSON attribute is reaching the Target system : DB Cols. 

 

How can i read this File and store the values in Property ? So, that i can compare with DB Cols.

 

JSON Row in a File:

{"uuid":"asdfsdf","assetType":["assetType:image/product-image"],"assetName":"asdfasdf324","class":["asdf23"],"sku":["2340000"],"subclass":["0000"],"renditions":{"original":"/C:/Local/image/product-image/41/4154/415483/415483an.psd",,"319x319":"/C:/Local/approved/image/product-image/41/4154/415483/415483an.psd.renditionpicker.319x319.png"}}

 

Mapping :

 

json field from a file

table field from DB

asset/assetName

ASSET_NAME

asset/assetType

ASSET_TYPE

asset/uuid

ASSET_UUID

asset/logoName

LOGO_NAME

asset/brand

BRAND

asset/sku

SKU

asset/expirationDate

EXPIRATION_DT

asset/class

CLASS_NAME

asset/subclass

SUBCLASS_NAME

asset/renditions/original

ORIG_FILE_PATH

asset/renditions/319x319

THUMBNAIL_FILE_PATH

 

Can anyone help on this. Thanks much.

Outcomes