Skip to Content
0
Jan 31, 2023 at 01:14 PM

Query to SFSF for extracting Offer Letter !!

434 Views

Dear Experts,

We need to extract offer letter from SFSF and for which I am using ODATA API - OfferLetter (GET) in CPI and the query used as below.

$select=offerLetterPDFmail/attachmentId,offerLetterPDFmail/fileContent,offerLetterPDFmail/fileName,offerLetterPDFmail/candidateNav/candidateId,offerLetterPDFmail/candidateNav/contactEmail,offerLetterPDFmail/candidateNav/firstName,offerLetterPDFmail/candidateNav/lastName,offerLetterPDFmail/candidateNav/primaryEmail,offerLetterId&$expand=offerLetterPDFmail,offerLetterPDFmail/candidateNav&$skip=6

With this query I am able to extract all the offer Letters available in the Test Tenant and the payload size in CPI is very big (around 52 - 60 MB) and not able to download as well to check the data.

I want to extract only one offer Letter at each call and next call should not poll the previously extracted Offer. Please suggest how can I do that.