Forum Discussion

MannyHernandez's avatar
MannyHernandez
Qrew Trainee
6 years ago

API Add_Record using URL Alternative and Field NAMEs rather than ID

Hello, Usually, I post new records via API using field IDs. For a new specific case, I have to use Field NAMES.  I see in the API documentation that this is supposed to be possible in theory. Bu...
AustinK's avatar
AustinK
Qrew Commander
6 years ago
Where did you see that using "fnm" instead of fid was the way to do it in the URL? I was unable to find information on that.

The only thing I see in the help doc you posted is that you can do this when you do an api call with XML. I don't see it mentioned that field name will work in the URL but I would be interested in figuring that one out too.

Why are you unable to use the field ID in this specific case? I'm just curious why that would be a limitation.
    • AustinK's avatar
      AustinK
      Qrew Commander
      6 years ago
      Yes that shows how to do it in an XML call but I am still not seeing where it says to replace fid with fnm. That was what I was wondering about because it sounded like they were using another resource than the regular docs.
      • MannyHernandez's avatar
        MannyHernandez
        Qrew Trainee
        6 years ago
        All the way at the bottom of that page it shows the URL alternative with the field name being used.

        I assume the FIELD ID and FIELD NAME would work both in XML or URL, otherwise why would that use it in that example.
        But, I am assuming here...

        Any insight or help would be truly appreciated! 




        ------------------------------
        Manny Hernandez
        ------------------------------
  • MannyHernandez's avatar
    MannyHernandez
    Qrew Trainee
    6 years ago
    @austink
    "Why are you unable to use the field ID in this specific case? I'm just curious why that would be a limitation."

    Homeadvisor post using a "simple" http post method that does not allow them to post using "custom fields." Dumbest thing ever... they can only post using their field names period. No way around it. 

    The solution, without using zapier, was to create a specific table with field names that would match theirs. once it comes into QB table, then I can auto-webhook it to drop into the proper table using field IDs and proper field types.     ​

    see their attached http instructions.

    ------------------------------
    Manny Hernandez
    ------------------------------
    • RyanStanford1's avatar
      RyanStanford1
      Qrew Captain
      6 years ago
      Would it be possible to make a field in QB to already premap the values you need into one field... and have that one compiled field to be the body of the webhook?

      ------------------------------
      Ryan Stanford
      ------------------------------