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