I am trying to implement the prunerows() ssjs function that Adam Spriggs specifies on this link, https://sprignaturemoves.com/prune-rows-data-extension-ssjs/

But i am not sure how to create a landing page to post to itself and then call this SSJS function. Can someone please explicitly specify what kind of SSJS code that i will need to have in the landing page to use the prunerows() function

Thanks for your help.

  • You can refer to this link here, salesforce.stackexchange.com/questions/176675/…
    – Kumar
    Jul 24, 2019 at 20:27
  • salesforce.stackexchange.com/questions/176675/… , You can refer here
    – Kumar
    Jul 24, 2019 at 20:28
  • @Kumar, thanks for your help. I am getting an error message "{"GetHeader":"function","GetQueryStringParameter":"function","GetFormField":"function","ApplicationID":null,"PackageID":null,"ApplicationBaseURL":null,"PagePath":null,"Method":"POST","IsAuthenticated":false,"URL":"function"}"
    – gds945
    Jul 24, 2019 at 23:17
  • @Kumar, do you know why? I just copy pasted the prunerows function into the code after where it says " else if (Request.Method == "POST") { // Handle post"
    – gds945
    Jul 24, 2019 at 23:19

1 Answer 1


Can you be more specific ? Where are you using your prunerows function and also the self posting landing page ? And your use case, so it is easy to give a better solution.

  • thanks for your help. I have actually figured out a better way to implement this. Since I was trying to delete like 100,000 records, i have found it is better to run the prunerows function in a script activity instead of a landing page.
    – gds945
    Jul 26, 2019 at 0:27
  • Sure, I could be of your help. So, did you loop through for retrieving 100,000 records? What was the script activity time to complete deletion? Share your code, so it can help other's. Thank you
    – Kumar
    Jul 26, 2019 at 14:33

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.