This service returns PO/PV detail records for OnBase: PopPrNo, PopPeId. Supports server-side pagination via TakeRows and SkipRows query parameters (e.g. TakeRows=100&SkipRows=0). Recommended for this large table (~28k rows).
using System.Net;
using Newtonsoft.Json.Linq;
public void MethodName(parms){
string uri = "https://fusion.superion.com/FusionOSServices/v0/ONESolution/OnBase/POPPVDetail";
using (WebClient wc = new WebClient())
{
wc.Headers.Add("Content-Type", "application/json");
// Replace "ID" with supplied AppID
wc.Headers.Set("X-APPID", "ID");
// Replace "KEY" with supplied AppKey
wc.Headers.Set("X-APPKEY", "KEY");
string result = wc.DownloadString(uri);
var response = JObject.Parse(result);
var records = (JContainer)response["values"];
foreach (var record in records)
{
string popPrNo = (string)record["popPrNo"];
string popPeId = (string)record["popPeId"];
}
}
}
{
"values": [
{
"popPrNo": "R04506",
"popPeId": "V00901"
}
],
"count": 1
}