Skip to main content
Solved

Getting Error with POST to currency field

  • January 13, 2024
  • 5 replies
  • 26 views

Forum|alt.badge.img+4

I am working in Postman. The field in question is "Taxes Owed - PDF". I get the error shown below. If I change the field type to single-line text I don't get an error. I don't want to change the field type. How do I avoid the error?  I have also tried other values: $3333, $3333.00, 3300.00, $3,333.00

TIA

{
    "error": {
        "type": "INVALID_VALUE_FOR_COLUMN",
        "message": "Field \\"Taxes Owed - PDF\\" cannot accept the provided value"
    }
}

 

{
    "fields": {
        "Case #": "12345",
        "File Date": "1/13/2024",
        "Taxes Owed - PDF": "3333"
    }
}

Best answer by Steve48

I was able to figure it out. Quotes should not be used for currency.

This worked:

{
    "fields": {
        "Case #": "12345",
        "File Date": "1/13/2024",
        "Taxes Owed - PDF": 3333
    }
}

 

5 replies

ScottWorld
Forum|alt.badge.img+35
  • Genius
  • 9808 replies
  • January 13, 2024

Do not put quotation marks around the number.


Forum|alt.badge.img+4
  • Author
  • New Participant
  • 3 replies
  • Answer
  • January 13, 2024

I was able to figure it out. Quotes should not be used for currency.

This worked:

{
    "fields": {
        "Case #": "12345",
        "File Date": "1/13/2024",
        "Taxes Owed - PDF": 3333
    }
}

 


ScottWorld
Forum|alt.badge.img+35
  • Genius
  • 9808 replies
  • January 13, 2024

Ha, yes. You probably didn’t see that I posted the answer a few minutes before you figured it out. 😝


Forum|alt.badge.img+4
  • Author
  • New Participant
  • 3 replies
  • January 13, 2024

Ha, yes. You probably didn’t see that I posted the answer a few minutes before you figured it out. 😝


posting. I marked your answer as asolution too.Yes- Thanks for


ScottWorld
Forum|alt.badge.img+35
  • Genius
  • 9808 replies
  • January 13, 2024

You’re welcome! I’m glad you figured it out on your own, too! Great job!! 😎🙌