Integration

Power Query

Power Query is the preferred Excel approach for lists because it can use ThreatPrevent bulk endpoints rather than making one browser-side request for every row.

Power Query M

let
    ApiUrl = "https://api.threatprevent.io/v1/payment-risk/bulk",
    ApiKey = "tp_...",

    Response =
        Json.Document(
            Web.Contents(
                ApiUrl,
                [
                    Headers = [
                        #"Content-Type" = "application/json",
                        #"x-api-key" = ApiKey
                    ],
                    Content = Json.FromValue([
                        emails = {
                            "one@example.com",
                            "two@example.com"
                        }
                    ])
                ]
            )
        )
in
    Response

Use bulk by default

Gather the values from the spreadsheet, deduplicate them, send one bulk request, then merge the returned results back into the table.