PublishDate when using API and filtering on the SettlementPoint

[jdm-incom]

When using this API endpoint explained here: https://apiexplorer.ercot.com/api-details#api=pubapi-apim-api&operation=getData_dam_stlmnt_pnt_prices

https://api.ercot.com/api/public-reports/np4-190-cd/dam_stlmnt_pnt_prices

I can filter on a single settlementPoint like:

settlementPoint=SOMETHING

But is it possible to filter on multiple settlementPoints in a single request?

And, when using this endpoint to get the same data:

https://misapi.ercot.com/misapp/servlets/IceDocListJsonWS?reportTypeId= 12331

We get a nice publishDate.
This date is missing, when using this api: https://api.ercot.com/api/public-reports/np4-190-cd/dam_stlmnt_pnt_prices

Is it possible to get this PublishDate, when using the rest api ?

[mackermann-ercot]

Hello jdm-incom,

When querying character based values such as settlementPoint, there is no concept of an "IN" clause for those values. Only single values can be queried at a time.

Also, to your second question, publishDate is not included in the contents of the data file that is ingested to produce the data set. Public API defines the data points for each report by what is provided in the same archive provided on the ercot.com site. There are a few exceptions to this, but unfortunately, this is not the case for NP4-190-CD. You can, however, download the archive for a given publish date (or range) using the archive resource endpoints, then use the data within those files.

Regards,
mackermann-ercot

[jdm-incom]

Thanks @mackermann-ercot , I think the archive api should work for now.