at the very least, you have to be able to do this the same way it is done in the UI. that may required two API calls, but that would still get it done....
--
Original Message:
Sent: 6/12/2023 2:34:00 PM
From: Ashish Rawat
Subject: RE: Can we limit number of records when exporting data in csv via api
You can use attribute level filter as well updateTimeFilter if it helps
e.g.,
{"ovOnly":true,"includeType":["configuration/entityTypes/Person"],"serviceName":"exportEntities","updateTimeFilter":{"since":1572978600000,"to":1736482599000}}
------------------------------
Ashish Rawat
Sr. Manager
Fresh Gravity
Bangalore
------------------------------
Original Message:
Sent: 06-12-2023 06:05
From: Inderjeet Kaur Sasan
Subject: Can we limit number of records when exporting data in csv via api
Hi Chetan,
Thanks for your reply, problem is- in get API this can be used, but not for export API. Below is what I am using-
https://na03-test.reltio.com/jobs/export/{{mdmTenant}}/entities?fileFormat=csv
Regards,
Inderjeet
------------------------------
Inderjeet Kaur Sasan
Eaton
Riddhi Towers,Viman Nagar
Original Message:
Sent: 06-12-2023 05:51
From: Chetan P
Subject: Can we limit number of records when exporting data in csv via api
Hi Inderjeet,
Hope this will be useful to you.
Below is the CURL used to limit number of profiles for an sample entity.
CURL used -
curl --location --request GET 'https://dev.reltio.com/reltio/api/xxxx/entities?max=200' \
--header 'Authorization: Bearer xxxx' \
--header 'Content-Type: application/json'
Let me know if this works.
Thanks & Regards,
------------------------------
Chetan P
Lead MDM Specialist
Freshworks
Chennai
Original Message:
Sent: 06-12-2023 04:37
From: Inderjeet Kaur Sasan
Subject: Can we limit number of records when exporting data in csv via api
I am doing a sampling of data based on a filter condition. But it is exporting all customers which is more than 4m records and is too much for sampling. Therefore I need to sample the data and export just 10k records.
------------------------------
Inderjeet Kaur Sasan
Eaton
Riddhi Towers,Viman Nagar
Original Message:
Sent: 06-10-2023 00:48
From: Gino Fortunato
Subject: Can we limit number of records when exporting data in csv via api
Hi Inderjeet,
Can you expand on why you want to limit the number of rows?
------------------------------
Gino Fortunato
Senior Solution Engineer
Reltio
Original Message:
Sent: 06-09-2023 10:30
From: Inderjeet Kaur Sasan
Subject: Can we limit number of records when exporting data in csv via api
Can we limit number of records when exporting data in csv via api
------------------------------
Inderjeet Kaur Sasan
Eaton
Riddhi Towers,Viman Nagar
------------------------------