Question

How to query the nested object of the service endpoint


Hi all,

My goal is to establish the relationship between vendor & project.

The Projectsprofile gives me the project ID

subcontractsPL gives me subcntract & vendor

But when I tried to query both I am not getting the project id back. I suspect its to do with the relationship. However I have tried creating the relationship through generic inquery but linking the POORder, SOOrder, Customer etc with the contractCD in PMProject. Another post I created related to OData is here

How to add project item to subcontract | Community (acumatica.com)

Any help would be much appreciated

JSON response below

{

    "id": "fc46c258-3934-434c-91e1-1afc1878d64c",

    "rowNumber": 1,

    "note": null,

    "Results": [

        {

            "id": "c538d497-8af3-ec11-9d80-4851c5051c10",

            "rowNumber": 1,

            "note": {

                "value": ""

            },

            "AccountIDBAccountR_AcctCD": {

                "value": "V000000001"

            },

            "AccountIDCustomer_bAccountID": {

                "value": 5441

            },

            "AccountIDVendor_bAccountID": {

                "value": 5532

            },

            "CustomerID": {

                "value": "C000000001"

            },

            "CustomerName": {

                "value": "Jersey Central Office Equip"

            },

            "Project": {

                "value": "X"

            },

            "SubcontractNbr": {

                "value": "SC-000004"

            },

            "VendorNamePOOrder_vendorID_description": {

                "value": "eQ Bank"

            },

            "VendorNameVendor_acctName": {

                "value": "eQ Bank"

            },

            "VendorPOOrder_vendorID": {

                "value": "V000000001"

            },

            "VendorVendor_AcctCD": {

                "value": "V000000001"

            },

            "custom": {}

        },

        {

            "id": "cb467071-82f3-ec11-9d80-4851c5051c10",

            "rowNumber": 2,

            "note": {

                "value": ""

            },

            "AccountIDBAccountR_AcctCD": {

                "value": "V000000001"

            },

            "AccountIDCustomer_bAccountID": {

                "value": 5441

            },

            "AccountIDVendor_bAccountID": {

                "value": 5532

            },

            "CustomerID": {

                "value": "C000000001"

            },

            "CustomerName": {

                "value": "Jersey Central Office Equip"

            },

            "Project": {

                "value": "X"

            },

            "SubcontractNbr": {

                "value": "SC-000003"

            },

            "VendorNamePOOrder_vendorID_description": {

                "value": "eQ Bank"

            },

            "VendorNameVendor_acctName": {

                "value": "eQ Bank"

            },

            "VendorPOOrder_vendorID": {

                "value": "V000000001"

            },

            "VendorVendor_AcctCD": {

                "value": "V000000001"

            },

            "custom": {}

        }

    ],

    "custom": {}

}

 


0 replies

Be the first to reply!

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved