PO_ID not matching back to the id for the PO

GraphQL API
1

Hello - I have recently been noticing that the PO_ID field that is brought back from the line_items endpoint is not the same as the ID in the purchase_orders endpoint. Here is an example:

query { 
    user_quota {
      is_expired
      time_remaining
      credits_remaining
    }
    purchase_orders {
      complexity
      request_id
      data(first: 1) {
          pageInfo {
              hasNextPage
              hasPreviousPage
              startCursor
              endCursor
        }
        edges {
          node {
             id
            po_number
            vendor_id
            created_at
            arrived_at
            po_date
            date_closed
            fulfillment_status
            shipping_carrier
            shipping_name
            shipping_price
            tracking_number
            payment_method
            payment_due_by
            subtotal
          }
          cursor
        }
        }
      }
    }

This returns the ID of UHVyY2hhc2VPcmRlcjozNTY1MjM= … but when i use that ID to get the purchase order lines from the purchase_order endpoint it returns a different value of 356523

query {
    user_quota {
        is_expired
        time_remaining
        credits_remaining
    }
    purchase_order(id: "UHVyY2hhc2VPcmRlcjozNTY1MjM=") {
        request_id
        complexity
        data {
            line_items(first: 5) {
                pageInfo {
                    hasNextPage
                    hasPreviousPage
                    startCursor
                    endCursor
                }
                edges {
                    node {
                        id
                        po_id
                        account_id
                        vendor_id
                        sku
                        vendor_sku
                        product_id
                        variant_id
                        product_name
                        quantity
                        quantity_received
                        quantity_rejected
                        sell_ahead
                        price
                        fulfillment_status
                        updated_at
                        created_at
                    }
                    cursor
                }
            }
        }
    }
}

Is there any insight into this? I was using this data to marry the data together in a table in our DWH. Please let me know ASAP.

Thanks,
Nick

2

Hi @rubix3!
That is correct
UHVyY2hhc2VPcmRlcjozNTY1MjM= should be the same as 356523
The reason they are different is that the first one is the encoded version of PurchaseOrder:356523

You can use any Base64 decoder to make this conversion if you need to match them like https://www.base64decode.org/ (or any decoder from any native coding language)

Please let us know if that doesn’t help.
Thanks in advance!
Tom