Help

Getting Error with POST to currency field

Topic Labels: API Scripting
Solved
Jump to Solution
776 5
cancel
Showing results for 
Search instead for 
Did you mean: 
Steve48
5 - Automation Enthusiast
5 - Automation Enthusiast

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"
    }
}
2 Solutions

Accepted Solutions
Steve48
5 - Automation Enthusiast
5 - Automation Enthusiast

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
    }
}

 

See Solution in Thread

ScottWorld
18 - Pluto
18 - Pluto

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

See Solution in Thread

5 Replies 5

Do not put quotation marks around the number.

Steve48
5 - Automation Enthusiast
5 - Automation Enthusiast

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
18 - Pluto
18 - Pluto

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
18 - Pluto
18 - Pluto

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