Custom fields information not coming in QB API in QuickBooks Advanced

It's great to see you here today, @BWTeam. I'm here to ensure you'll get the right support in completing your task about custom field information using QuickBooks Online (QBO) Advanced.

We have a separate and dedicated forum that handles API concerns for QBO Advanced. This is the place where developers, engage with others to discuss programming concerns. I'd suggest posting your question from there. This way, they can provide you an accurate resolution to fix the issue about custom fields. I'll guide you how. 

1. Go to this link: https://help.developer.intuit.com/s/.
2. Choose QuickBooks Desktop under What do you need help with?. 
3. Click Ask a Question. 
4. Log into your existing Intuit Developer Account or create a new one. 
5. Enter your concern. 
6. Click Ask. 

I've attached screenshots below that shows the first four steps.

Also, you can utilize the helpful API topics (i.e., API Explorer ) through the API Docs & Tools menu for further reference. 

Please keep me posted on how it goes. You can count me in if you have other concerns. I'll gladly help. Take care and stay safe.

Okay, thank you.

Okay, thank you for your help.

Hi 

We have contacted your team and they have found a bug in the custom fields received from the QuickBooks Advanced App. So they said that they will fix this issue in a week.

You can check the below link to see the conversation:

[Removed]

Thank you for your help.

Hi

This issue is not resolved yet.

Our customers are still facing the custom fields issue. They are not getting the string-type custom fields information in the API response.

It's been 2 months since we are facing this problem. We have attached our Customer custom fields response and custom fields screenshot in QuickBooks.

This is the QuickBooks realmid : [removed]

App: QuickBooks Online Advanced

Query we have used: Select * from Preferences.

Can you please ask your team to troubleshoot the issue from your end? or Can you escalate this case to the higher person? Since May our customers are facing this issue. Please help me ASAP.

This isn't the impression that I'd like you to be left with, @BWTeam.

Rest assured that I'm making it my top priority that your suggestion reaches our Development Team. I'd also recommend contacting again our Developer Support. This way, they can assist you further with the API response.

In case you need help with other tasks in QBO. Feel free to click this link. It has our general topics with articles.

Reach out to me anytime if you have questions or concerns with invoices. I'll be here for you. Take care and have a nice day ahead.

@BWTeam we had the same or similar issue during our integration. Our quickbooks account had 2 custom fields, but weren't returning in the preferences query. According to the api docs, the api only returns the first 3. Turns out, we had 3 inactive custom fields, so we had to rename those to our desired fields and make them active. Not sure this is your issue, but thought it was worth noting since quickbooks support on here is sub-optimal.

This should be the accepted answer. "Only the first three custom fields of type String" means that you take the first three fields, chronologically by creation date (!!!), of type String, active or inactive, *then* keep only the active ones. So if the first three String-type custom fields you ever created are all inactive, the API will return no custom fields.

When you're viewing custom fields, by default they're sorted chronologically, so the fields you're looking for will be at the end of the list. I don't think you can achieve that sort order again if you sort by one of the columns without refreshing the page.