You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Skip to content
  • Register

    • how to Retrieve the GUID of a row (global unique identifier ) using SQL ,not REST

    in BI Publisher Learning Center

    some apis require the GUID  to update a record , not the id or rowid
    We can retrieve that value using REST api

    (/fscmRestApi/resources/11.13.18.05/invoices/1/child/invoiceInstallment)

    but we want to get the value using SQL statements

    ex : we want that value "00020000000EACED0005770800000000000000010000000EACED000577080000000000000001"

    /fscmRestApi/resources/11.13.18.05/invoices/1/child/invoiceInstallments/00020000000EACED0005770800000000000000010000000EACED000577080000000000000001/child/invoiceInstallmentDff/00020000000EACED0005770800000000000000010000000EACED000577080000000000000001",

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

    Don't have an account? Click here to get started!