Page Comparison

...

• Table

  • Tables can only be created (or dropped) via REST APIhttps://api.pricefx.com/openapi/pricefx/reference/pricefx/operation/post-kvservice. createtable/. You can do this in HTTP API console in Studio, see Test Rest API Calls.

• Store data

  • void writeKV(String tableName, Map<String, Object> keys, Object payload)

  • void writeKV(String tableName, Map<String, Object> keys, String jsonPayload)

  • void writeKVBulk(String tableName, List<String> header, List<List> data)

• Retrieve data

  • String getKV(String tableName, Map<String, Object> keys)

  • List<Map<String,Object>> fecthKV(String tableName, Map<String, Object> filters, int maxRows)

  • long countKV(String tableName)

• Delete data

  • void removeKV(String tableName, Map<String, Object> keys)

  • void truncateKV(String tableName)

...

The complete REST API for the Key Value store, including examples, is documented at https://api.pricefx.com/openapi/pricefx/reference/pricefx/tag/Key-Value-Store/.

The following REST API endpoints are available:

• Table

  • https://api.pricefx.com/openapi/reference/pricefx/operation/post-kvservice.createtable/

  • https://api.pricefx.com/openapi/reference/pricefx/operation/get-kvservice.listtables/

  • https://api.pricefx.com/openapi/reference/pricefx/operation/get-kvservice.describetable-tableName/

  • https://api.pricefx.com/openapi/reference/pricefx/operation/post-kvservice.droptable/

• Store data

  • https://api.pricefx.com/openapi/reference/pricefx/operation/post-kvservice.putkey/

  • https://api.pricefx.com/openapi/reference/pricefx/operation/post-kvservice.loaddata-tableName/

• Retrieve data

  • https://api.pricefx.com/openapi/reference/pricefx/operation/post-kvservice.fetchkey-tableName/

  • https://api.pricefx.com/openapi/reference/pricefx/operation/post-kvservice.fetch-tableName/

  • https://api.pricefx.com/openapi/reference/pricefx/operation/get-kvservice.count-tableName/

• Delete data

  • https://api.pricefx.com/openapi/reference/pricefx/operation/post-kvservice.removekey-tableName/

  • https://api.pricefx.com/openapi/reference/pricefx/operation/get-kvservice.truncate-tableName/

Examples

The following examples explain the basic usage of the API endpoints.

...