Skip to main content
Solved

Add CreatedByID and ModifiedByID in CHECK web service endpoint


I was working on with the "Get" method in Acumatica API, I successfully pull the records from the api however there is no userID of the creator and modifier.

Webservice Endpoints I tried to find the createdBy and ModifiedBy in the dropdown but there is none.

how to add the UserID of creator and modifier on the web service endpoint so that these fields will be parts of the Get response.

Thanks in Advance

Best answer by Mike Gifford

Try referencing it through the custom parameter: https://help.acumatica.com/Help?ScreenId=ShowWiki&pageid=a0444120-2e5d-41cd-8c65-0385210b0f8a

I have been able to access standard fields not in the endpoint this way in the past. Worth a shot.

View original
Did this topic help you find an answer to your question?

3 replies

RohitRattan88
Acumatica Moderator
Forum|alt.badge.img+4
  • Acumatica Moderator
  • 253 replies
  • November 3, 2023

@bunnyboy04 

I believe these system fields are not exposed via API for some(many) screens. 

As a workaround though, you could try adding an Unbound field to store these value and pull it in the API:

How to get stored value of custom field instead of displayed value in web service endpoint | Community (acumatica.com)

 

Hopefully it helps


Mike Gifford
Jr Varsity III
Forum|alt.badge.img
  • Jr Varsity III
  • 25 replies
  • Answer
  • November 3, 2023

Try referencing it through the custom parameter: https://help.acumatica.com/Help?ScreenId=ShowWiki&pageid=a0444120-2e5d-41cd-8c65-0385210b0f8a

I have been able to access standard fields not in the endpoint this way in the past. Worth a shot.


  • Jr Varsity I
  • 5 replies
  • November 8, 2023

I can confirm this should work using @Mike Gifford’s suggestion of the custom parameter.  For example to get the Created By and Last Modified By fields for a Vendor record, I’d perform a GET request to: https://{instance url}/entity/Default/20.200.001/Vendor/{vendor_acctID}?$custom=BAccount.CreatedByID, BAccount.LastModifiedByID

and within the body of the response find these fields within the “custom” element:

}
    ...,
    "custom": {
        "BAccount": {
            "CreatedByID": {
                "type": "CustomStringField",
                "value": "admin"
            },
            "LastModifiedByID": {
                "type": "CustomStringField",
                "value": "jturcotte"
            }
        }
    },
    ...
}

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings