Custom field on Order not found

API Q&A
1

I’m trying to query the “Job” table via the XML-RPC API and fetch a field called “Tracking Number”, which appears under fulfillment. I also found that the API name of this field is TrackingNumber. However, when I try to query the API I get an error:

$sdk->data()->query('Job', 1, 0, ['Id' => 2003521],  ['TrackingNumber'], 'Id', false);
// Infusionsoft/Http/HttpException with message '[NoFieldFound]No field found: Job.TrackingNumber'

I’m sure the API name is correct, and I can confirm that it’s happening with other custom fields as well.

Any help?

2

Custom Fields need to be prefixed with an Underscore, eg: “_TrackingNumber”.

1 Like