Question
1. Query regarding export unmapped values. The limit attribute looks working till 1000, it does not work beyond it,
For example- for lookup AWARDS_CATEGORY have around 1.5k unmapped values.
API executed:
GET https://rdm.reltio.com/unmapped/rdmtenantid ?filter=equals(type,'AWARDS_CATEGORY')&sort=code&order=asc&limit=2000
The result received contains only 1000 records, but in the RDM tenant we have 1503 unmapped values, need a way to get all these values
Solution
You can get this information in two ways:
1. Use
offset search instruction. (You can calculate offset by the formula: the offset = limit * number_of_pack first pack has number 0 )For example:
First pack:
First pack:
GET: https://rdm.reltio.com/unmapped/CezUstqP4Izqfhm?filter=equals(type,'AWARDS_CATEGORY')&sort=code&order=asc&limit=100&offset=0
Second pack:
GET: https://rdm.reltio.com/unmapped/CezUstqP4Izqfhm?filter=equals(type,'AWARDS_CATEGORY')&sort=code&order=asc&limit=100&offset=100
2. Use
dbscan instruction - to get values from the Datastore without filtering. For it executes the following request (with an empty body)POST: https://rdm.reltio.com/unmapped/CezUstqP4Izqfhm/_dbscan?filter=equals(type,'AWARDS_CATEGORY')&limit=100 BODY:
Get
"scrollId" from the response and send it as a body to get the next packFor example
POST: https://rdm.reltio.com/unmapped/CezUstqP4Izqfhm/_dbscan?filter=equals(type,'AWARDS_CATEGORY')&limit=100 BODY: CpEBEooBag1wfnByb2QtMTU1NDIycmILEhB....ZW50DKIBFERBVEFfQ2V6VXN0cVA0SXpxZmhtGAAgAA
you should repeat this request until the response has a
"scrollId" fieldIf the unmapped values are less than 10'000 you can use the first example. If more than 10'000 please use the second example.
Comments
Please sign in to leave a comment.