Skip to main content
GET
/
secured
/
getProductosPublicados
curl --location 'http://localhost:8080/secured/getProductosPublicados' \
--header 'Authorization: YOUR_JWT_TOKEN'

{
  "status": 200,
  "datos": [
    {
      "id": 1,
      "claveProductoP": "PROD001",
      "descripcionP": "High-quality electronic component",
      "woocomerce": "WOO"
    },
    {
      "id": 2,
      "claveProductoP": "PROD002",
      "descripcionP": "Accessory item",
      "woocomerce": "WOO"
    }
  ]
}
This endpoint returns a list of products that have been published to WooCommerce by joining the productos_publicados and productossae tables.

​
Authentication

This endpoint requires authentication. Include a valid JWT token in the Authorization header (raw token, no “Bearer” prefix).
​
Authorization
string
required
JWT token for authentication (raw token without Bearer prefix)

​
Response

​
status
number
HTTP status code (200 for success)
​
datos
array
Array of published product objects
curl --location 'http://localhost:8080/secured/getProductosPublicados' \
--header 'Authorization: YOUR_JWT_TOKEN'

{
  "status": 200,
  "datos": [
    {
      "id": 1,
      "claveProductoP": "PROD001",
      "descripcionP": "High-quality electronic component",
      "woocomerce": "WOO"
    },
    {
      "id": 2,
      "claveProductoP": "PROD002",
      "descripcionP": "Accessory item",
      "woocomerce": "WOO"
    }
  ]
}

​
Error Codes

​
200
success
Successfully retrieved published products
​
401
error
Unauthorized - Invalid or missing authentication token

​
Implementation Notes

  • Performs an INNER JOIN between productos_publicados (P) and productossae (S) tables (line 251 in cliente.js:251)
  • Join condition: P.claveProductoP = S.claveProducto
  • Only returns products that have been published to WooCommerce
  • The woocomerce field typically contains the value “WOO”

Build docs developers (and LLMs) love

Get started for freeTalk to us